package com.ssish.saas.eccs.model;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class ProviderExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public ProviderExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andProviderCodeIsNull() {
            addCriterion("PROVIDER_CODE is null");
            return (Criteria) this;
        }

        public Criteria andProviderCodeIsNotNull() {
            addCriterion("PROVIDER_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andProviderCodeEqualTo(String value) {
            addCriterion("PROVIDER_CODE =", value, "providerCode");
            return (Criteria) this;
        }

        public Criteria andProviderCodeNotEqualTo(String value) {
            addCriterion("PROVIDER_CODE <>", value, "providerCode");
            return (Criteria) this;
        }

        public Criteria andProviderCodeGreaterThan(String value) {
            addCriterion("PROVIDER_CODE >", value, "providerCode");
            return (Criteria) this;
        }

        public Criteria andProviderCodeGreaterThanOrEqualTo(String value) {
            addCriterion("PROVIDER_CODE >=", value, "providerCode");
            return (Criteria) this;
        }

        public Criteria andProviderCodeLessThan(String value) {
            addCriterion("PROVIDER_CODE <", value, "providerCode");
            return (Criteria) this;
        }

        public Criteria andProviderCodeLessThanOrEqualTo(String value) {
            addCriterion("PROVIDER_CODE <=", value, "providerCode");
            return (Criteria) this;
        }

        public Criteria andProviderCodeLike(String value) {
            addCriterion("PROVIDER_CODE like", value, "providerCode");
            return (Criteria) this;
        }

        public Criteria andProviderCodeNotLike(String value) {
            addCriterion("PROVIDER_CODE not like", value, "providerCode");
            return (Criteria) this;
        }

        public Criteria andProviderCodeIn(List<String> values) {
            addCriterion("PROVIDER_CODE in", values, "providerCode");
            return (Criteria) this;
        }

        public Criteria andProviderCodeNotIn(List<String> values) {
            addCriterion("PROVIDER_CODE not in", values, "providerCode");
            return (Criteria) this;
        }

        public Criteria andProviderCodeBetween(String value1, String value2) {
            addCriterion("PROVIDER_CODE between", value1, value2, "providerCode");
            return (Criteria) this;
        }

        public Criteria andProviderCodeNotBetween(String value1, String value2) {
            addCriterion("PROVIDER_CODE not between", value1, value2, "providerCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeIsNull() {
            addCriterion("USER_CODE is null");
            return (Criteria) this;
        }

        public Criteria andUserCodeIsNotNull() {
            addCriterion("USER_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andUserCodeEqualTo(String value) {
            addCriterion("USER_CODE =", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeNotEqualTo(String value) {
            addCriterion("USER_CODE <>", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeGreaterThan(String value) {
            addCriterion("USER_CODE >", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeGreaterThanOrEqualTo(String value) {
            addCriterion("USER_CODE >=", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeLessThan(String value) {
            addCriterion("USER_CODE <", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeLessThanOrEqualTo(String value) {
            addCriterion("USER_CODE <=", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeLike(String value) {
            addCriterion("USER_CODE like", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeNotLike(String value) {
            addCriterion("USER_CODE not like", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeIn(List<String> values) {
            addCriterion("USER_CODE in", values, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeNotIn(List<String> values) {
            addCriterion("USER_CODE not in", values, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeBetween(String value1, String value2) {
            addCriterion("USER_CODE between", value1, value2, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeNotBetween(String value1, String value2) {
            addCriterion("USER_CODE not between", value1, value2, "userCode");
            return (Criteria) this;
        }

        public Criteria andTmClaimcatIsNull() {
            addCriterion("TM_CLAIMCAT is null");
            return (Criteria) this;
        }

        public Criteria andTmClaimcatIsNotNull() {
            addCriterion("TM_CLAIMCAT is not null");
            return (Criteria) this;
        }

        public Criteria andTmClaimcatEqualTo(String value) {
            addCriterion("TM_CLAIMCAT =", value, "tmClaimcat");
            return (Criteria) this;
        }

        public Criteria andTmClaimcatNotEqualTo(String value) {
            addCriterion("TM_CLAIMCAT <>", value, "tmClaimcat");
            return (Criteria) this;
        }

        public Criteria andTmClaimcatGreaterThan(String value) {
            addCriterion("TM_CLAIMCAT >", value, "tmClaimcat");
            return (Criteria) this;
        }

        public Criteria andTmClaimcatGreaterThanOrEqualTo(String value) {
            addCriterion("TM_CLAIMCAT >=", value, "tmClaimcat");
            return (Criteria) this;
        }

        public Criteria andTmClaimcatLessThan(String value) {
            addCriterion("TM_CLAIMCAT <", value, "tmClaimcat");
            return (Criteria) this;
        }

        public Criteria andTmClaimcatLessThanOrEqualTo(String value) {
            addCriterion("TM_CLAIMCAT <=", value, "tmClaimcat");
            return (Criteria) this;
        }

        public Criteria andTmClaimcatLike(String value) {
            addCriterion("TM_CLAIMCAT like", value, "tmClaimcat");
            return (Criteria) this;
        }

        public Criteria andTmClaimcatNotLike(String value) {
            addCriterion("TM_CLAIMCAT not like", value, "tmClaimcat");
            return (Criteria) this;
        }

        public Criteria andTmClaimcatIn(List<String> values) {
            addCriterion("TM_CLAIMCAT in", values, "tmClaimcat");
            return (Criteria) this;
        }

        public Criteria andTmClaimcatNotIn(List<String> values) {
            addCriterion("TM_CLAIMCAT not in", values, "tmClaimcat");
            return (Criteria) this;
        }

        public Criteria andTmClaimcatBetween(String value1, String value2) {
            addCriterion("TM_CLAIMCAT between", value1, value2, "tmClaimcat");
            return (Criteria) this;
        }

        public Criteria andTmClaimcatNotBetween(String value1, String value2) {
            addCriterion("TM_CLAIMCAT not between", value1, value2, "tmClaimcat");
            return (Criteria) this;
        }

        public Criteria andCorpCodeIsNull() {
            addCriterion("CORP_CODE is null");
            return (Criteria) this;
        }

        public Criteria andCorpCodeIsNotNull() {
            addCriterion("CORP_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andCorpCodeEqualTo(String value) {
            addCriterion("CORP_CODE =", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeNotEqualTo(String value) {
            addCriterion("CORP_CODE <>", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeGreaterThan(String value) {
            addCriterion("CORP_CODE >", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeGreaterThanOrEqualTo(String value) {
            addCriterion("CORP_CODE >=", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeLessThan(String value) {
            addCriterion("CORP_CODE <", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeLessThanOrEqualTo(String value) {
            addCriterion("CORP_CODE <=", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeLike(String value) {
            addCriterion("CORP_CODE like", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeNotLike(String value) {
            addCriterion("CORP_CODE not like", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeIn(List<String> values) {
            addCriterion("CORP_CODE in", values, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeNotIn(List<String> values) {
            addCriterion("CORP_CODE not in", values, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeBetween(String value1, String value2) {
            addCriterion("CORP_CODE between", value1, value2, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeNotBetween(String value1, String value2) {
            addCriterion("CORP_CODE not between", value1, value2, "corpCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeIsNull() {
            addCriterion("PAYOR_CODE is null");
            return (Criteria) this;
        }

        public Criteria andPayorCodeIsNotNull() {
            addCriterion("PAYOR_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andPayorCodeEqualTo(String value) {
            addCriterion("PAYOR_CODE =", value, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeNotEqualTo(String value) {
            addCriterion("PAYOR_CODE <>", value, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeGreaterThan(String value) {
            addCriterion("PAYOR_CODE >", value, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeGreaterThanOrEqualTo(String value) {
            addCriterion("PAYOR_CODE >=", value, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeLessThan(String value) {
            addCriterion("PAYOR_CODE <", value, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeLessThanOrEqualTo(String value) {
            addCriterion("PAYOR_CODE <=", value, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeLike(String value) {
            addCriterion("PAYOR_CODE like", value, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeNotLike(String value) {
            addCriterion("PAYOR_CODE not like", value, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeIn(List<String> values) {
            addCriterion("PAYOR_CODE in", values, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeNotIn(List<String> values) {
            addCriterion("PAYOR_CODE not in", values, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeBetween(String value1, String value2) {
            addCriterion("PAYOR_CODE between", value1, value2, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeNotBetween(String value1, String value2) {
            addCriterion("PAYOR_CODE not between", value1, value2, "payorCode");
            return (Criteria) this;
        }

        public Criteria andProviderTypeIsNull() {
            addCriterion("PROVIDER_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andProviderTypeIsNotNull() {
            addCriterion("PROVIDER_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andProviderTypeEqualTo(String value) {
            addCriterion("PROVIDER_TYPE =", value, "providerType");
            return (Criteria) this;
        }

        public Criteria andProviderTypeNotEqualTo(String value) {
            addCriterion("PROVIDER_TYPE <>", value, "providerType");
            return (Criteria) this;
        }

        public Criteria andProviderTypeGreaterThan(String value) {
            addCriterion("PROVIDER_TYPE >", value, "providerType");
            return (Criteria) this;
        }

        public Criteria andProviderTypeGreaterThanOrEqualTo(String value) {
            addCriterion("PROVIDER_TYPE >=", value, "providerType");
            return (Criteria) this;
        }

        public Criteria andProviderTypeLessThan(String value) {
            addCriterion("PROVIDER_TYPE <", value, "providerType");
            return (Criteria) this;
        }

        public Criteria andProviderTypeLessThanOrEqualTo(String value) {
            addCriterion("PROVIDER_TYPE <=", value, "providerType");
            return (Criteria) this;
        }

        public Criteria andProviderTypeLike(String value) {
            addCriterion("PROVIDER_TYPE like", value, "providerType");
            return (Criteria) this;
        }

        public Criteria andProviderTypeNotLike(String value) {
            addCriterion("PROVIDER_TYPE not like", value, "providerType");
            return (Criteria) this;
        }

        public Criteria andProviderTypeIn(List<String> values) {
            addCriterion("PROVIDER_TYPE in", values, "providerType");
            return (Criteria) this;
        }

        public Criteria andProviderTypeNotIn(List<String> values) {
            addCriterion("PROVIDER_TYPE not in", values, "providerType");
            return (Criteria) this;
        }

        public Criteria andProviderTypeBetween(String value1, String value2) {
            addCriterion("PROVIDER_TYPE between", value1, value2, "providerType");
            return (Criteria) this;
        }

        public Criteria andProviderTypeNotBetween(String value1, String value2) {
            addCriterion("PROVIDER_TYPE not between", value1, value2, "providerType");
            return (Criteria) this;
        }

        public Criteria andShortNameIsNull() {
            addCriterion("SHORT_NAME is null");
            return (Criteria) this;
        }

        public Criteria andShortNameIsNotNull() {
            addCriterion("SHORT_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andShortNameEqualTo(Object value) {
            addCriterion("SHORT_NAME =", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameNotEqualTo(Object value) {
            addCriterion("SHORT_NAME <>", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameGreaterThan(Object value) {
            addCriterion("SHORT_NAME >", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameGreaterThanOrEqualTo(Object value) {
            addCriterion("SHORT_NAME >=", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameLessThan(Object value) {
            addCriterion("SHORT_NAME <", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameLessThanOrEqualTo(Object value) {
            addCriterion("SHORT_NAME <=", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameIn(List<Object> values) {
            addCriterion("SHORT_NAME in", values, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameNotIn(List<Object> values) {
            addCriterion("SHORT_NAME not in", values, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameBetween(Object value1, Object value2) {
            addCriterion("SHORT_NAME between", value1, value2, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameNotBetween(Object value1, Object value2) {
            addCriterion("SHORT_NAME not between", value1, value2, "shortName");
            return (Criteria) this;
        }

        public Criteria andLongNameIsNull() {
            addCriterion("LONG_NAME is null");
            return (Criteria) this;
        }

        public Criteria andLongNameIsNotNull() {
            addCriterion("LONG_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andLongNameEqualTo(Object value) {
            addCriterion("LONG_NAME =", value, "longName");
            return (Criteria) this;
        }

        public Criteria andLongNameNotEqualTo(Object value) {
            addCriterion("LONG_NAME <>", value, "longName");
            return (Criteria) this;
        }

        public Criteria andLongNameGreaterThan(Object value) {
            addCriterion("LONG_NAME >", value, "longName");
            return (Criteria) this;
        }

        public Criteria andLongNameGreaterThanOrEqualTo(Object value) {
            addCriterion("LONG_NAME >=", value, "longName");
            return (Criteria) this;
        }

        public Criteria andLongNameLessThan(Object value) {
            addCriterion("LONG_NAME <", value, "longName");
            return (Criteria) this;
        }

        public Criteria andLongNameLessThanOrEqualTo(Object value) {
            addCriterion("LONG_NAME <=", value, "longName");
            return (Criteria) this;
        }

        public Criteria andLongNameIn(List<Object> values) {
            addCriterion("LONG_NAME in", values, "longName");
            return (Criteria) this;
        }

        public Criteria andLongNameNotIn(List<Object> values) {
            addCriterion("LONG_NAME not in", values, "longName");
            return (Criteria) this;
        }

        public Criteria andLongNameBetween(Object value1, Object value2) {
            addCriterion("LONG_NAME between", value1, value2, "longName");
            return (Criteria) this;
        }

        public Criteria andLongNameNotBetween(Object value1, Object value2) {
            addCriterion("LONG_NAME not between", value1, value2, "longName");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("ADDRESS is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("ADDRESS is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(Object value) {
            addCriterion("ADDRESS =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(Object value) {
            addCriterion("ADDRESS <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(Object value) {
            addCriterion("ADDRESS >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(Object value) {
            addCriterion("ADDRESS >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(Object value) {
            addCriterion("ADDRESS <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(Object value) {
            addCriterion("ADDRESS <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<Object> values) {
            addCriterion("ADDRESS in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<Object> values) {
            addCriterion("ADDRESS not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(Object value1, Object value2) {
            addCriterion("ADDRESS between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(Object value1, Object value2) {
            addCriterion("ADDRESS not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andPostcodeIsNull() {
            addCriterion("POSTCODE is null");
            return (Criteria) this;
        }

        public Criteria andPostcodeIsNotNull() {
            addCriterion("POSTCODE is not null");
            return (Criteria) this;
        }

        public Criteria andPostcodeEqualTo(String value) {
            addCriterion("POSTCODE =", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotEqualTo(String value) {
            addCriterion("POSTCODE <>", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeGreaterThan(String value) {
            addCriterion("POSTCODE >", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeGreaterThanOrEqualTo(String value) {
            addCriterion("POSTCODE >=", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeLessThan(String value) {
            addCriterion("POSTCODE <", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeLessThanOrEqualTo(String value) {
            addCriterion("POSTCODE <=", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeLike(String value) {
            addCriterion("POSTCODE like", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotLike(String value) {
            addCriterion("POSTCODE not like", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeIn(List<String> values) {
            addCriterion("POSTCODE in", values, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotIn(List<String> values) {
            addCriterion("POSTCODE not in", values, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeBetween(String value1, String value2) {
            addCriterion("POSTCODE between", value1, value2, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotBetween(String value1, String value2) {
            addCriterion("POSTCODE not between", value1, value2, "postcode");
            return (Criteria) this;
        }

        public Criteria andCityIsNull() {
            addCriterion("CITY is null");
            return (Criteria) this;
        }

        public Criteria andCityIsNotNull() {
            addCriterion("CITY is not null");
            return (Criteria) this;
        }

        public Criteria andCityEqualTo(String value) {
            addCriterion("CITY =", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotEqualTo(String value) {
            addCriterion("CITY <>", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThan(String value) {
            addCriterion("CITY >", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThanOrEqualTo(String value) {
            addCriterion("CITY >=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThan(String value) {
            addCriterion("CITY <", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThanOrEqualTo(String value) {
            addCriterion("CITY <=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLike(String value) {
            addCriterion("CITY like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotLike(String value) {
            addCriterion("CITY not like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityIn(List<String> values) {
            addCriterion("CITY in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotIn(List<String> values) {
            addCriterion("CITY not in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityBetween(String value1, String value2) {
            addCriterion("CITY between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotBetween(String value1, String value2) {
            addCriterion("CITY not between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andStateIsNull() {
            addCriterion("STATE is null");
            return (Criteria) this;
        }

        public Criteria andStateIsNotNull() {
            addCriterion("STATE is not null");
            return (Criteria) this;
        }

        public Criteria andStateEqualTo(String value) {
            addCriterion("STATE =", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotEqualTo(String value) {
            addCriterion("STATE <>", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateGreaterThan(String value) {
            addCriterion("STATE >", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateGreaterThanOrEqualTo(String value) {
            addCriterion("STATE >=", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLessThan(String value) {
            addCriterion("STATE <", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLessThanOrEqualTo(String value) {
            addCriterion("STATE <=", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLike(String value) {
            addCriterion("STATE like", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotLike(String value) {
            addCriterion("STATE not like", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateIn(List<String> values) {
            addCriterion("STATE in", values, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotIn(List<String> values) {
            addCriterion("STATE not in", values, "state");
            return (Criteria) this;
        }

        public Criteria andStateBetween(String value1, String value2) {
            addCriterion("STATE between", value1, value2, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotBetween(String value1, String value2) {
            addCriterion("STATE not between", value1, value2, "state");
            return (Criteria) this;
        }

        public Criteria andCountryIsNull() {
            addCriterion("COUNTRY is null");
            return (Criteria) this;
        }

        public Criteria andCountryIsNotNull() {
            addCriterion("COUNTRY is not null");
            return (Criteria) this;
        }

        public Criteria andCountryEqualTo(String value) {
            addCriterion("COUNTRY =", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryNotEqualTo(String value) {
            addCriterion("COUNTRY <>", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryGreaterThan(String value) {
            addCriterion("COUNTRY >", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryGreaterThanOrEqualTo(String value) {
            addCriterion("COUNTRY >=", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryLessThan(String value) {
            addCriterion("COUNTRY <", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryLessThanOrEqualTo(String value) {
            addCriterion("COUNTRY <=", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryLike(String value) {
            addCriterion("COUNTRY like", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryNotLike(String value) {
            addCriterion("COUNTRY not like", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryIn(List<String> values) {
            addCriterion("COUNTRY in", values, "country");
            return (Criteria) this;
        }

        public Criteria andCountryNotIn(List<String> values) {
            addCriterion("COUNTRY not in", values, "country");
            return (Criteria) this;
        }

        public Criteria andCountryBetween(String value1, String value2) {
            addCriterion("COUNTRY between", value1, value2, "country");
            return (Criteria) this;
        }

        public Criteria andCountryNotBetween(String value1, String value2) {
            addCriterion("COUNTRY not between", value1, value2, "country");
            return (Criteria) this;
        }

        public Criteria andTelNo1IsNull() {
            addCriterion("TEL_NO1 is null");
            return (Criteria) this;
        }

        public Criteria andTelNo1IsNotNull() {
            addCriterion("TEL_NO1 is not null");
            return (Criteria) this;
        }

        public Criteria andTelNo1EqualTo(String value) {
            addCriterion("TEL_NO1 =", value, "telNo1");
            return (Criteria) this;
        }

        public Criteria andTelNo1NotEqualTo(String value) {
            addCriterion("TEL_NO1 <>", value, "telNo1");
            return (Criteria) this;
        }

        public Criteria andTelNo1GreaterThan(String value) {
            addCriterion("TEL_NO1 >", value, "telNo1");
            return (Criteria) this;
        }

        public Criteria andTelNo1GreaterThanOrEqualTo(String value) {
            addCriterion("TEL_NO1 >=", value, "telNo1");
            return (Criteria) this;
        }

        public Criteria andTelNo1LessThan(String value) {
            addCriterion("TEL_NO1 <", value, "telNo1");
            return (Criteria) this;
        }

        public Criteria andTelNo1LessThanOrEqualTo(String value) {
            addCriterion("TEL_NO1 <=", value, "telNo1");
            return (Criteria) this;
        }

        public Criteria andTelNo1Like(String value) {
            addCriterion("TEL_NO1 like", value, "telNo1");
            return (Criteria) this;
        }

        public Criteria andTelNo1NotLike(String value) {
            addCriterion("TEL_NO1 not like", value, "telNo1");
            return (Criteria) this;
        }

        public Criteria andTelNo1In(List<String> values) {
            addCriterion("TEL_NO1 in", values, "telNo1");
            return (Criteria) this;
        }

        public Criteria andTelNo1NotIn(List<String> values) {
            addCriterion("TEL_NO1 not in", values, "telNo1");
            return (Criteria) this;
        }

        public Criteria andTelNo1Between(String value1, String value2) {
            addCriterion("TEL_NO1 between", value1, value2, "telNo1");
            return (Criteria) this;
        }

        public Criteria andTelNo1NotBetween(String value1, String value2) {
            addCriterion("TEL_NO1 not between", value1, value2, "telNo1");
            return (Criteria) this;
        }

        public Criteria andTelNo2IsNull() {
            addCriterion("TEL_NO2 is null");
            return (Criteria) this;
        }

        public Criteria andTelNo2IsNotNull() {
            addCriterion("TEL_NO2 is not null");
            return (Criteria) this;
        }

        public Criteria andTelNo2EqualTo(String value) {
            addCriterion("TEL_NO2 =", value, "telNo2");
            return (Criteria) this;
        }

        public Criteria andTelNo2NotEqualTo(String value) {
            addCriterion("TEL_NO2 <>", value, "telNo2");
            return (Criteria) this;
        }

        public Criteria andTelNo2GreaterThan(String value) {
            addCriterion("TEL_NO2 >", value, "telNo2");
            return (Criteria) this;
        }

        public Criteria andTelNo2GreaterThanOrEqualTo(String value) {
            addCriterion("TEL_NO2 >=", value, "telNo2");
            return (Criteria) this;
        }

        public Criteria andTelNo2LessThan(String value) {
            addCriterion("TEL_NO2 <", value, "telNo2");
            return (Criteria) this;
        }

        public Criteria andTelNo2LessThanOrEqualTo(String value) {
            addCriterion("TEL_NO2 <=", value, "telNo2");
            return (Criteria) this;
        }

        public Criteria andTelNo2Like(String value) {
            addCriterion("TEL_NO2 like", value, "telNo2");
            return (Criteria) this;
        }

        public Criteria andTelNo2NotLike(String value) {
            addCriterion("TEL_NO2 not like", value, "telNo2");
            return (Criteria) this;
        }

        public Criteria andTelNo2In(List<String> values) {
            addCriterion("TEL_NO2 in", values, "telNo2");
            return (Criteria) this;
        }

        public Criteria andTelNo2NotIn(List<String> values) {
            addCriterion("TEL_NO2 not in", values, "telNo2");
            return (Criteria) this;
        }

        public Criteria andTelNo2Between(String value1, String value2) {
            addCriterion("TEL_NO2 between", value1, value2, "telNo2");
            return (Criteria) this;
        }

        public Criteria andTelNo2NotBetween(String value1, String value2) {
            addCriterion("TEL_NO2 not between", value1, value2, "telNo2");
            return (Criteria) this;
        }

        public Criteria andAdminNameIsNull() {
            addCriterion("ADMIN_NAME is null");
            return (Criteria) this;
        }

        public Criteria andAdminNameIsNotNull() {
            addCriterion("ADMIN_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andAdminNameEqualTo(String value) {
            addCriterion("ADMIN_NAME =", value, "adminName");
            return (Criteria) this;
        }

        public Criteria andAdminNameNotEqualTo(String value) {
            addCriterion("ADMIN_NAME <>", value, "adminName");
            return (Criteria) this;
        }

        public Criteria andAdminNameGreaterThan(String value) {
            addCriterion("ADMIN_NAME >", value, "adminName");
            return (Criteria) this;
        }

        public Criteria andAdminNameGreaterThanOrEqualTo(String value) {
            addCriterion("ADMIN_NAME >=", value, "adminName");
            return (Criteria) this;
        }

        public Criteria andAdminNameLessThan(String value) {
            addCriterion("ADMIN_NAME <", value, "adminName");
            return (Criteria) this;
        }

        public Criteria andAdminNameLessThanOrEqualTo(String value) {
            addCriterion("ADMIN_NAME <=", value, "adminName");
            return (Criteria) this;
        }

        public Criteria andAdminNameLike(String value) {
            addCriterion("ADMIN_NAME like", value, "adminName");
            return (Criteria) this;
        }

        public Criteria andAdminNameNotLike(String value) {
            addCriterion("ADMIN_NAME not like", value, "adminName");
            return (Criteria) this;
        }

        public Criteria andAdminNameIn(List<String> values) {
            addCriterion("ADMIN_NAME in", values, "adminName");
            return (Criteria) this;
        }

        public Criteria andAdminNameNotIn(List<String> values) {
            addCriterion("ADMIN_NAME not in", values, "adminName");
            return (Criteria) this;
        }

        public Criteria andAdminNameBetween(String value1, String value2) {
            addCriterion("ADMIN_NAME between", value1, value2, "adminName");
            return (Criteria) this;
        }

        public Criteria andAdminNameNotBetween(String value1, String value2) {
            addCriterion("ADMIN_NAME not between", value1, value2, "adminName");
            return (Criteria) this;
        }

        public Criteria andFaxNoIsNull() {
            addCriterion("FAX_NO is null");
            return (Criteria) this;
        }

        public Criteria andFaxNoIsNotNull() {
            addCriterion("FAX_NO is not null");
            return (Criteria) this;
        }

        public Criteria andFaxNoEqualTo(String value) {
            addCriterion("FAX_NO =", value, "faxNo");
            return (Criteria) this;
        }

        public Criteria andFaxNoNotEqualTo(String value) {
            addCriterion("FAX_NO <>", value, "faxNo");
            return (Criteria) this;
        }

        public Criteria andFaxNoGreaterThan(String value) {
            addCriterion("FAX_NO >", value, "faxNo");
            return (Criteria) this;
        }

        public Criteria andFaxNoGreaterThanOrEqualTo(String value) {
            addCriterion("FAX_NO >=", value, "faxNo");
            return (Criteria) this;
        }

        public Criteria andFaxNoLessThan(String value) {
            addCriterion("FAX_NO <", value, "faxNo");
            return (Criteria) this;
        }

        public Criteria andFaxNoLessThanOrEqualTo(String value) {
            addCriterion("FAX_NO <=", value, "faxNo");
            return (Criteria) this;
        }

        public Criteria andFaxNoLike(String value) {
            addCriterion("FAX_NO like", value, "faxNo");
            return (Criteria) this;
        }

        public Criteria andFaxNoNotLike(String value) {
            addCriterion("FAX_NO not like", value, "faxNo");
            return (Criteria) this;
        }

        public Criteria andFaxNoIn(List<String> values) {
            addCriterion("FAX_NO in", values, "faxNo");
            return (Criteria) this;
        }

        public Criteria andFaxNoNotIn(List<String> values) {
            addCriterion("FAX_NO not in", values, "faxNo");
            return (Criteria) this;
        }

        public Criteria andFaxNoBetween(String value1, String value2) {
            addCriterion("FAX_NO between", value1, value2, "faxNo");
            return (Criteria) this;
        }

        public Criteria andFaxNoNotBetween(String value1, String value2) {
            addCriterion("FAX_NO not between", value1, value2, "faxNo");
            return (Criteria) this;
        }

        public Criteria andEmailIsNull() {
            addCriterion("EMAIL is null");
            return (Criteria) this;
        }

        public Criteria andEmailIsNotNull() {
            addCriterion("EMAIL is not null");
            return (Criteria) this;
        }

        public Criteria andEmailEqualTo(String value) {
            addCriterion("EMAIL =", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotEqualTo(String value) {
            addCriterion("EMAIL <>", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThan(String value) {
            addCriterion("EMAIL >", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThanOrEqualTo(String value) {
            addCriterion("EMAIL >=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThan(String value) {
            addCriterion("EMAIL <", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThanOrEqualTo(String value) {
            addCriterion("EMAIL <=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLike(String value) {
            addCriterion("EMAIL like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotLike(String value) {
            addCriterion("EMAIL not like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailIn(List<String> values) {
            addCriterion("EMAIL in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotIn(List<String> values) {
            addCriterion("EMAIL not in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailBetween(String value1, String value2) {
            addCriterion("EMAIL between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotBetween(String value1, String value2) {
            addCriterion("EMAIL not between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andEdiAddressIsNull() {
            addCriterion("EDI_ADDRESS is null");
            return (Criteria) this;
        }

        public Criteria andEdiAddressIsNotNull() {
            addCriterion("EDI_ADDRESS is not null");
            return (Criteria) this;
        }

        public Criteria andEdiAddressEqualTo(String value) {
            addCriterion("EDI_ADDRESS =", value, "ediAddress");
            return (Criteria) this;
        }

        public Criteria andEdiAddressNotEqualTo(String value) {
            addCriterion("EDI_ADDRESS <>", value, "ediAddress");
            return (Criteria) this;
        }

        public Criteria andEdiAddressGreaterThan(String value) {
            addCriterion("EDI_ADDRESS >", value, "ediAddress");
            return (Criteria) this;
        }

        public Criteria andEdiAddressGreaterThanOrEqualTo(String value) {
            addCriterion("EDI_ADDRESS >=", value, "ediAddress");
            return (Criteria) this;
        }

        public Criteria andEdiAddressLessThan(String value) {
            addCriterion("EDI_ADDRESS <", value, "ediAddress");
            return (Criteria) this;
        }

        public Criteria andEdiAddressLessThanOrEqualTo(String value) {
            addCriterion("EDI_ADDRESS <=", value, "ediAddress");
            return (Criteria) this;
        }

        public Criteria andEdiAddressLike(String value) {
            addCriterion("EDI_ADDRESS like", value, "ediAddress");
            return (Criteria) this;
        }

        public Criteria andEdiAddressNotLike(String value) {
            addCriterion("EDI_ADDRESS not like", value, "ediAddress");
            return (Criteria) this;
        }

        public Criteria andEdiAddressIn(List<String> values) {
            addCriterion("EDI_ADDRESS in", values, "ediAddress");
            return (Criteria) this;
        }

        public Criteria andEdiAddressNotIn(List<String> values) {
            addCriterion("EDI_ADDRESS not in", values, "ediAddress");
            return (Criteria) this;
        }

        public Criteria andEdiAddressBetween(String value1, String value2) {
            addCriterion("EDI_ADDRESS between", value1, value2, "ediAddress");
            return (Criteria) this;
        }

        public Criteria andEdiAddressNotBetween(String value1, String value2) {
            addCriterion("EDI_ADDRESS not between", value1, value2, "ediAddress");
            return (Criteria) this;
        }

        public Criteria andActiveFlagIsNull() {
            addCriterion("ACTIVE_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andActiveFlagIsNotNull() {
            addCriterion("ACTIVE_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andActiveFlagEqualTo(String value) {
            addCriterion("ACTIVE_FLAG =", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagNotEqualTo(String value) {
            addCriterion("ACTIVE_FLAG <>", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagGreaterThan(String value) {
            addCriterion("ACTIVE_FLAG >", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagGreaterThanOrEqualTo(String value) {
            addCriterion("ACTIVE_FLAG >=", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagLessThan(String value) {
            addCriterion("ACTIVE_FLAG <", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagLessThanOrEqualTo(String value) {
            addCriterion("ACTIVE_FLAG <=", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagLike(String value) {
            addCriterion("ACTIVE_FLAG like", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagNotLike(String value) {
            addCriterion("ACTIVE_FLAG not like", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagIn(List<String> values) {
            addCriterion("ACTIVE_FLAG in", values, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagNotIn(List<String> values) {
            addCriterion("ACTIVE_FLAG not in", values, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagBetween(String value1, String value2) {
            addCriterion("ACTIVE_FLAG between", value1, value2, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagNotBetween(String value1, String value2) {
            addCriterion("ACTIVE_FLAG not between", value1, value2, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andBusinessHour1IsNull() {
            addCriterion("BUSINESS_HOUR1 is null");
            return (Criteria) this;
        }

        public Criteria andBusinessHour1IsNotNull() {
            addCriterion("BUSINESS_HOUR1 is not null");
            return (Criteria) this;
        }

        public Criteria andBusinessHour1EqualTo(String value) {
            addCriterion("BUSINESS_HOUR1 =", value, "businessHour1");
            return (Criteria) this;
        }

        public Criteria andBusinessHour1NotEqualTo(String value) {
            addCriterion("BUSINESS_HOUR1 <>", value, "businessHour1");
            return (Criteria) this;
        }

        public Criteria andBusinessHour1GreaterThan(String value) {
            addCriterion("BUSINESS_HOUR1 >", value, "businessHour1");
            return (Criteria) this;
        }

        public Criteria andBusinessHour1GreaterThanOrEqualTo(String value) {
            addCriterion("BUSINESS_HOUR1 >=", value, "businessHour1");
            return (Criteria) this;
        }

        public Criteria andBusinessHour1LessThan(String value) {
            addCriterion("BUSINESS_HOUR1 <", value, "businessHour1");
            return (Criteria) this;
        }

        public Criteria andBusinessHour1LessThanOrEqualTo(String value) {
            addCriterion("BUSINESS_HOUR1 <=", value, "businessHour1");
            return (Criteria) this;
        }

        public Criteria andBusinessHour1Like(String value) {
            addCriterion("BUSINESS_HOUR1 like", value, "businessHour1");
            return (Criteria) this;
        }

        public Criteria andBusinessHour1NotLike(String value) {
            addCriterion("BUSINESS_HOUR1 not like", value, "businessHour1");
            return (Criteria) this;
        }

        public Criteria andBusinessHour1In(List<String> values) {
            addCriterion("BUSINESS_HOUR1 in", values, "businessHour1");
            return (Criteria) this;
        }

        public Criteria andBusinessHour1NotIn(List<String> values) {
            addCriterion("BUSINESS_HOUR1 not in", values, "businessHour1");
            return (Criteria) this;
        }

        public Criteria andBusinessHour1Between(String value1, String value2) {
            addCriterion("BUSINESS_HOUR1 between", value1, value2, "businessHour1");
            return (Criteria) this;
        }

        public Criteria andBusinessHour1NotBetween(String value1, String value2) {
            addCriterion("BUSINESS_HOUR1 not between", value1, value2, "businessHour1");
            return (Criteria) this;
        }

        public Criteria andBusinessHour2IsNull() {
            addCriterion("BUSINESS_HOUR2 is null");
            return (Criteria) this;
        }

        public Criteria andBusinessHour2IsNotNull() {
            addCriterion("BUSINESS_HOUR2 is not null");
            return (Criteria) this;
        }

        public Criteria andBusinessHour2EqualTo(String value) {
            addCriterion("BUSINESS_HOUR2 =", value, "businessHour2");
            return (Criteria) this;
        }

        public Criteria andBusinessHour2NotEqualTo(String value) {
            addCriterion("BUSINESS_HOUR2 <>", value, "businessHour2");
            return (Criteria) this;
        }

        public Criteria andBusinessHour2GreaterThan(String value) {
            addCriterion("BUSINESS_HOUR2 >", value, "businessHour2");
            return (Criteria) this;
        }

        public Criteria andBusinessHour2GreaterThanOrEqualTo(String value) {
            addCriterion("BUSINESS_HOUR2 >=", value, "businessHour2");
            return (Criteria) this;
        }

        public Criteria andBusinessHour2LessThan(String value) {
            addCriterion("BUSINESS_HOUR2 <", value, "businessHour2");
            return (Criteria) this;
        }

        public Criteria andBusinessHour2LessThanOrEqualTo(String value) {
            addCriterion("BUSINESS_HOUR2 <=", value, "businessHour2");
            return (Criteria) this;
        }

        public Criteria andBusinessHour2Like(String value) {
            addCriterion("BUSINESS_HOUR2 like", value, "businessHour2");
            return (Criteria) this;
        }

        public Criteria andBusinessHour2NotLike(String value) {
            addCriterion("BUSINESS_HOUR2 not like", value, "businessHour2");
            return (Criteria) this;
        }

        public Criteria andBusinessHour2In(List<String> values) {
            addCriterion("BUSINESS_HOUR2 in", values, "businessHour2");
            return (Criteria) this;
        }

        public Criteria andBusinessHour2NotIn(List<String> values) {
            addCriterion("BUSINESS_HOUR2 not in", values, "businessHour2");
            return (Criteria) this;
        }

        public Criteria andBusinessHour2Between(String value1, String value2) {
            addCriterion("BUSINESS_HOUR2 between", value1, value2, "businessHour2");
            return (Criteria) this;
        }

        public Criteria andBusinessHour2NotBetween(String value1, String value2) {
            addCriterion("BUSINESS_HOUR2 not between", value1, value2, "businessHour2");
            return (Criteria) this;
        }

        public Criteria andEdiClaimsIsNull() {
            addCriterion("EDI_CLAIMS is null");
            return (Criteria) this;
        }

        public Criteria andEdiClaimsIsNotNull() {
            addCriterion("EDI_CLAIMS is not null");
            return (Criteria) this;
        }

        public Criteria andEdiClaimsEqualTo(String value) {
            addCriterion("EDI_CLAIMS =", value, "ediClaims");
            return (Criteria) this;
        }

        public Criteria andEdiClaimsNotEqualTo(String value) {
            addCriterion("EDI_CLAIMS <>", value, "ediClaims");
            return (Criteria) this;
        }

        public Criteria andEdiClaimsGreaterThan(String value) {
            addCriterion("EDI_CLAIMS >", value, "ediClaims");
            return (Criteria) this;
        }

        public Criteria andEdiClaimsGreaterThanOrEqualTo(String value) {
            addCriterion("EDI_CLAIMS >=", value, "ediClaims");
            return (Criteria) this;
        }

        public Criteria andEdiClaimsLessThan(String value) {
            addCriterion("EDI_CLAIMS <", value, "ediClaims");
            return (Criteria) this;
        }

        public Criteria andEdiClaimsLessThanOrEqualTo(String value) {
            addCriterion("EDI_CLAIMS <=", value, "ediClaims");
            return (Criteria) this;
        }

        public Criteria andEdiClaimsLike(String value) {
            addCriterion("EDI_CLAIMS like", value, "ediClaims");
            return (Criteria) this;
        }

        public Criteria andEdiClaimsNotLike(String value) {
            addCriterion("EDI_CLAIMS not like", value, "ediClaims");
            return (Criteria) this;
        }

        public Criteria andEdiClaimsIn(List<String> values) {
            addCriterion("EDI_CLAIMS in", values, "ediClaims");
            return (Criteria) this;
        }

        public Criteria andEdiClaimsNotIn(List<String> values) {
            addCriterion("EDI_CLAIMS not in", values, "ediClaims");
            return (Criteria) this;
        }

        public Criteria andEdiClaimsBetween(String value1, String value2) {
            addCriterion("EDI_CLAIMS between", value1, value2, "ediClaims");
            return (Criteria) this;
        }

        public Criteria andEdiClaimsNotBetween(String value1, String value2) {
            addCriterion("EDI_CLAIMS not between", value1, value2, "ediClaims");
            return (Criteria) this;
        }

        public Criteria andCommCodeIsNull() {
            addCriterion("COMM_CODE is null");
            return (Criteria) this;
        }

        public Criteria andCommCodeIsNotNull() {
            addCriterion("COMM_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andCommCodeEqualTo(String value) {
            addCriterion("COMM_CODE =", value, "commCode");
            return (Criteria) this;
        }

        public Criteria andCommCodeNotEqualTo(String value) {
            addCriterion("COMM_CODE <>", value, "commCode");
            return (Criteria) this;
        }

        public Criteria andCommCodeGreaterThan(String value) {
            addCriterion("COMM_CODE >", value, "commCode");
            return (Criteria) this;
        }

        public Criteria andCommCodeGreaterThanOrEqualTo(String value) {
            addCriterion("COMM_CODE >=", value, "commCode");
            return (Criteria) this;
        }

        public Criteria andCommCodeLessThan(String value) {
            addCriterion("COMM_CODE <", value, "commCode");
            return (Criteria) this;
        }

        public Criteria andCommCodeLessThanOrEqualTo(String value) {
            addCriterion("COMM_CODE <=", value, "commCode");
            return (Criteria) this;
        }

        public Criteria andCommCodeLike(String value) {
            addCriterion("COMM_CODE like", value, "commCode");
            return (Criteria) this;
        }

        public Criteria andCommCodeNotLike(String value) {
            addCriterion("COMM_CODE not like", value, "commCode");
            return (Criteria) this;
        }

        public Criteria andCommCodeIn(List<String> values) {
            addCriterion("COMM_CODE in", values, "commCode");
            return (Criteria) this;
        }

        public Criteria andCommCodeNotIn(List<String> values) {
            addCriterion("COMM_CODE not in", values, "commCode");
            return (Criteria) this;
        }

        public Criteria andCommCodeBetween(String value1, String value2) {
            addCriterion("COMM_CODE between", value1, value2, "commCode");
            return (Criteria) this;
        }

        public Criteria andCommCodeNotBetween(String value1, String value2) {
            addCriterion("COMM_CODE not between", value1, value2, "commCode");
            return (Criteria) this;
        }

        public Criteria andInvoiceFormatIsNull() {
            addCriterion("INVOICE_FORMAT is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceFormatIsNotNull() {
            addCriterion("INVOICE_FORMAT is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceFormatEqualTo(Short value) {
            addCriterion("INVOICE_FORMAT =", value, "invoiceFormat");
            return (Criteria) this;
        }

        public Criteria andInvoiceFormatNotEqualTo(Short value) {
            addCriterion("INVOICE_FORMAT <>", value, "invoiceFormat");
            return (Criteria) this;
        }

        public Criteria andInvoiceFormatGreaterThan(Short value) {
            addCriterion("INVOICE_FORMAT >", value, "invoiceFormat");
            return (Criteria) this;
        }

        public Criteria andInvoiceFormatGreaterThanOrEqualTo(Short value) {
            addCriterion("INVOICE_FORMAT >=", value, "invoiceFormat");
            return (Criteria) this;
        }

        public Criteria andInvoiceFormatLessThan(Short value) {
            addCriterion("INVOICE_FORMAT <", value, "invoiceFormat");
            return (Criteria) this;
        }

        public Criteria andInvoiceFormatLessThanOrEqualTo(Short value) {
            addCriterion("INVOICE_FORMAT <=", value, "invoiceFormat");
            return (Criteria) this;
        }

        public Criteria andInvoiceFormatIn(List<Short> values) {
            addCriterion("INVOICE_FORMAT in", values, "invoiceFormat");
            return (Criteria) this;
        }

        public Criteria andInvoiceFormatNotIn(List<Short> values) {
            addCriterion("INVOICE_FORMAT not in", values, "invoiceFormat");
            return (Criteria) this;
        }

        public Criteria andInvoiceFormatBetween(Short value1, Short value2) {
            addCriterion("INVOICE_FORMAT between", value1, value2, "invoiceFormat");
            return (Criteria) this;
        }

        public Criteria andInvoiceFormatNotBetween(Short value1, Short value2) {
            addCriterion("INVOICE_FORMAT not between", value1, value2, "invoiceFormat");
            return (Criteria) this;
        }

        public Criteria andParticipateFlagIsNull() {
            addCriterion("PARTICIPATE_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andParticipateFlagIsNotNull() {
            addCriterion("PARTICIPATE_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andParticipateFlagEqualTo(String value) {
            addCriterion("PARTICIPATE_FLAG =", value, "participateFlag");
            return (Criteria) this;
        }

        public Criteria andParticipateFlagNotEqualTo(String value) {
            addCriterion("PARTICIPATE_FLAG <>", value, "participateFlag");
            return (Criteria) this;
        }

        public Criteria andParticipateFlagGreaterThan(String value) {
            addCriterion("PARTICIPATE_FLAG >", value, "participateFlag");
            return (Criteria) this;
        }

        public Criteria andParticipateFlagGreaterThanOrEqualTo(String value) {
            addCriterion("PARTICIPATE_FLAG >=", value, "participateFlag");
            return (Criteria) this;
        }

        public Criteria andParticipateFlagLessThan(String value) {
            addCriterion("PARTICIPATE_FLAG <", value, "participateFlag");
            return (Criteria) this;
        }

        public Criteria andParticipateFlagLessThanOrEqualTo(String value) {
            addCriterion("PARTICIPATE_FLAG <=", value, "participateFlag");
            return (Criteria) this;
        }

        public Criteria andParticipateFlagLike(String value) {
            addCriterion("PARTICIPATE_FLAG like", value, "participateFlag");
            return (Criteria) this;
        }

        public Criteria andParticipateFlagNotLike(String value) {
            addCriterion("PARTICIPATE_FLAG not like", value, "participateFlag");
            return (Criteria) this;
        }

        public Criteria andParticipateFlagIn(List<String> values) {
            addCriterion("PARTICIPATE_FLAG in", values, "participateFlag");
            return (Criteria) this;
        }

        public Criteria andParticipateFlagNotIn(List<String> values) {
            addCriterion("PARTICIPATE_FLAG not in", values, "participateFlag");
            return (Criteria) this;
        }

        public Criteria andParticipateFlagBetween(String value1, String value2) {
            addCriterion("PARTICIPATE_FLAG between", value1, value2, "participateFlag");
            return (Criteria) this;
        }

        public Criteria andParticipateFlagNotBetween(String value1, String value2) {
            addCriterion("PARTICIPATE_FLAG not between", value1, value2, "participateFlag");
            return (Criteria) this;
        }

        public Criteria andBankIdIsNull() {
            addCriterion("BANK_ID is null");
            return (Criteria) this;
        }

        public Criteria andBankIdIsNotNull() {
            addCriterion("BANK_ID is not null");
            return (Criteria) this;
        }

        public Criteria andBankIdEqualTo(Integer value) {
            addCriterion("BANK_ID =", value, "bankId");
            return (Criteria) this;
        }

        public Criteria andBankIdNotEqualTo(Integer value) {
            addCriterion("BANK_ID <>", value, "bankId");
            return (Criteria) this;
        }

        public Criteria andBankIdGreaterThan(Integer value) {
            addCriterion("BANK_ID >", value, "bankId");
            return (Criteria) this;
        }

        public Criteria andBankIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("BANK_ID >=", value, "bankId");
            return (Criteria) this;
        }

        public Criteria andBankIdLessThan(Integer value) {
            addCriterion("BANK_ID <", value, "bankId");
            return (Criteria) this;
        }

        public Criteria andBankIdLessThanOrEqualTo(Integer value) {
            addCriterion("BANK_ID <=", value, "bankId");
            return (Criteria) this;
        }

        public Criteria andBankIdIn(List<Integer> values) {
            addCriterion("BANK_ID in", values, "bankId");
            return (Criteria) this;
        }

        public Criteria andBankIdNotIn(List<Integer> values) {
            addCriterion("BANK_ID not in", values, "bankId");
            return (Criteria) this;
        }

        public Criteria andBankIdBetween(Integer value1, Integer value2) {
            addCriterion("BANK_ID between", value1, value2, "bankId");
            return (Criteria) this;
        }

        public Criteria andBankIdNotBetween(Integer value1, Integer value2) {
            addCriterion("BANK_ID not between", value1, value2, "bankId");
            return (Criteria) this;
        }

        public Criteria andBankCodeIsNull() {
            addCriterion("BANK_CODE is null");
            return (Criteria) this;
        }

        public Criteria andBankCodeIsNotNull() {
            addCriterion("BANK_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andBankCodeEqualTo(String value) {
            addCriterion("BANK_CODE =", value, "bankCode");
            return (Criteria) this;
        }

        public Criteria andBankCodeNotEqualTo(String value) {
            addCriterion("BANK_CODE <>", value, "bankCode");
            return (Criteria) this;
        }

        public Criteria andBankCodeGreaterThan(String value) {
            addCriterion("BANK_CODE >", value, "bankCode");
            return (Criteria) this;
        }

        public Criteria andBankCodeGreaterThanOrEqualTo(String value) {
            addCriterion("BANK_CODE >=", value, "bankCode");
            return (Criteria) this;
        }

        public Criteria andBankCodeLessThan(String value) {
            addCriterion("BANK_CODE <", value, "bankCode");
            return (Criteria) this;
        }

        public Criteria andBankCodeLessThanOrEqualTo(String value) {
            addCriterion("BANK_CODE <=", value, "bankCode");
            return (Criteria) this;
        }

        public Criteria andBankCodeLike(String value) {
            addCriterion("BANK_CODE like", value, "bankCode");
            return (Criteria) this;
        }

        public Criteria andBankCodeNotLike(String value) {
            addCriterion("BANK_CODE not like", value, "bankCode");
            return (Criteria) this;
        }

        public Criteria andBankCodeIn(List<String> values) {
            addCriterion("BANK_CODE in", values, "bankCode");
            return (Criteria) this;
        }

        public Criteria andBankCodeNotIn(List<String> values) {
            addCriterion("BANK_CODE not in", values, "bankCode");
            return (Criteria) this;
        }

        public Criteria andBankCodeBetween(String value1, String value2) {
            addCriterion("BANK_CODE between", value1, value2, "bankCode");
            return (Criteria) this;
        }

        public Criteria andBankCodeNotBetween(String value1, String value2) {
            addCriterion("BANK_CODE not between", value1, value2, "bankCode");
            return (Criteria) this;
        }

        public Criteria andBankAcNoIsNull() {
            addCriterion("BANK_AC_NO is null");
            return (Criteria) this;
        }

        public Criteria andBankAcNoIsNotNull() {
            addCriterion("BANK_AC_NO is not null");
            return (Criteria) this;
        }

        public Criteria andBankAcNoEqualTo(String value) {
            addCriterion("BANK_AC_NO =", value, "bankAcNo");
            return (Criteria) this;
        }

        public Criteria andBankAcNoNotEqualTo(String value) {
            addCriterion("BANK_AC_NO <>", value, "bankAcNo");
            return (Criteria) this;
        }

        public Criteria andBankAcNoGreaterThan(String value) {
            addCriterion("BANK_AC_NO >", value, "bankAcNo");
            return (Criteria) this;
        }

        public Criteria andBankAcNoGreaterThanOrEqualTo(String value) {
            addCriterion("BANK_AC_NO >=", value, "bankAcNo");
            return (Criteria) this;
        }

        public Criteria andBankAcNoLessThan(String value) {
            addCriterion("BANK_AC_NO <", value, "bankAcNo");
            return (Criteria) this;
        }

        public Criteria andBankAcNoLessThanOrEqualTo(String value) {
            addCriterion("BANK_AC_NO <=", value, "bankAcNo");
            return (Criteria) this;
        }

        public Criteria andBankAcNoLike(String value) {
            addCriterion("BANK_AC_NO like", value, "bankAcNo");
            return (Criteria) this;
        }

        public Criteria andBankAcNoNotLike(String value) {
            addCriterion("BANK_AC_NO not like", value, "bankAcNo");
            return (Criteria) this;
        }

        public Criteria andBankAcNoIn(List<String> values) {
            addCriterion("BANK_AC_NO in", values, "bankAcNo");
            return (Criteria) this;
        }

        public Criteria andBankAcNoNotIn(List<String> values) {
            addCriterion("BANK_AC_NO not in", values, "bankAcNo");
            return (Criteria) this;
        }

        public Criteria andBankAcNoBetween(String value1, String value2) {
            addCriterion("BANK_AC_NO between", value1, value2, "bankAcNo");
            return (Criteria) this;
        }

        public Criteria andBankAcNoNotBetween(String value1, String value2) {
            addCriterion("BANK_AC_NO not between", value1, value2, "bankAcNo");
            return (Criteria) this;
        }

        public Criteria andLasteditDateIsNull() {
            addCriterion("LASTEDIT_DATE is null");
            return (Criteria) this;
        }

        public Criteria andLasteditDateIsNotNull() {
            addCriterion("LASTEDIT_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andLasteditDateEqualTo(Date value) {
            addCriterion("LASTEDIT_DATE =", value, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andLasteditDateNotEqualTo(Date value) {
            addCriterion("LASTEDIT_DATE <>", value, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andLasteditDateGreaterThan(Date value) {
            addCriterion("LASTEDIT_DATE >", value, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andLasteditDateGreaterThanOrEqualTo(Date value) {
            addCriterion("LASTEDIT_DATE >=", value, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andLasteditDateLessThan(Date value) {
            addCriterion("LASTEDIT_DATE <", value, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andLasteditDateLessThanOrEqualTo(Date value) {
            addCriterion("LASTEDIT_DATE <=", value, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andLasteditDateIn(List<Date> values) {
            addCriterion("LASTEDIT_DATE in", values, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andLasteditDateNotIn(List<Date> values) {
            addCriterion("LASTEDIT_DATE not in", values, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andLasteditDateBetween(Date value1, Date value2) {
            addCriterion("LASTEDIT_DATE between", value1, value2, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andLasteditDateNotBetween(Date value1, Date value2) {
            addCriterion("LASTEDIT_DATE not between", value1, value2, "lasteditDate");
            return (Criteria) this;
        }

        public Criteria andMerchantCodeIsNull() {
            addCriterion("MERCHANT_CODE is null");
            return (Criteria) this;
        }

        public Criteria andMerchantCodeIsNotNull() {
            addCriterion("MERCHANT_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andMerchantCodeEqualTo(String value) {
            addCriterion("MERCHANT_CODE =", value, "merchantCode");
            return (Criteria) this;
        }

        public Criteria andMerchantCodeNotEqualTo(String value) {
            addCriterion("MERCHANT_CODE <>", value, "merchantCode");
            return (Criteria) this;
        }

        public Criteria andMerchantCodeGreaterThan(String value) {
            addCriterion("MERCHANT_CODE >", value, "merchantCode");
            return (Criteria) this;
        }

        public Criteria andMerchantCodeGreaterThanOrEqualTo(String value) {
            addCriterion("MERCHANT_CODE >=", value, "merchantCode");
            return (Criteria) this;
        }

        public Criteria andMerchantCodeLessThan(String value) {
            addCriterion("MERCHANT_CODE <", value, "merchantCode");
            return (Criteria) this;
        }

        public Criteria andMerchantCodeLessThanOrEqualTo(String value) {
            addCriterion("MERCHANT_CODE <=", value, "merchantCode");
            return (Criteria) this;
        }

        public Criteria andMerchantCodeLike(String value) {
            addCriterion("MERCHANT_CODE like", value, "merchantCode");
            return (Criteria) this;
        }

        public Criteria andMerchantCodeNotLike(String value) {
            addCriterion("MERCHANT_CODE not like", value, "merchantCode");
            return (Criteria) this;
        }

        public Criteria andMerchantCodeIn(List<String> values) {
            addCriterion("MERCHANT_CODE in", values, "merchantCode");
            return (Criteria) this;
        }

        public Criteria andMerchantCodeNotIn(List<String> values) {
            addCriterion("MERCHANT_CODE not in", values, "merchantCode");
            return (Criteria) this;
        }

        public Criteria andMerchantCodeBetween(String value1, String value2) {
            addCriterion("MERCHANT_CODE between", value1, value2, "merchantCode");
            return (Criteria) this;
        }

        public Criteria andMerchantCodeNotBetween(String value1, String value2) {
            addCriterion("MERCHANT_CODE not between", value1, value2, "merchantCode");
            return (Criteria) this;
        }

        public Criteria andBankAcNameIsNull() {
            addCriterion("BANK_AC_NAME is null");
            return (Criteria) this;
        }

        public Criteria andBankAcNameIsNotNull() {
            addCriterion("BANK_AC_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andBankAcNameEqualTo(Object value) {
            addCriterion("BANK_AC_NAME =", value, "bankAcName");
            return (Criteria) this;
        }

        public Criteria andBankAcNameNotEqualTo(Object value) {
            addCriterion("BANK_AC_NAME <>", value, "bankAcName");
            return (Criteria) this;
        }

        public Criteria andBankAcNameGreaterThan(Object value) {
            addCriterion("BANK_AC_NAME >", value, "bankAcName");
            return (Criteria) this;
        }

        public Criteria andBankAcNameGreaterThanOrEqualTo(Object value) {
            addCriterion("BANK_AC_NAME >=", value, "bankAcName");
            return (Criteria) this;
        }

        public Criteria andBankAcNameLessThan(Object value) {
            addCriterion("BANK_AC_NAME <", value, "bankAcName");
            return (Criteria) this;
        }

        public Criteria andBankAcNameLessThanOrEqualTo(Object value) {
            addCriterion("BANK_AC_NAME <=", value, "bankAcName");
            return (Criteria) this;
        }

        public Criteria andBankAcNameIn(List<Object> values) {
            addCriterion("BANK_AC_NAME in", values, "bankAcName");
            return (Criteria) this;
        }

        public Criteria andBankAcNameNotIn(List<Object> values) {
            addCriterion("BANK_AC_NAME not in", values, "bankAcName");
            return (Criteria) this;
        }

        public Criteria andBankAcNameBetween(Object value1, Object value2) {
            addCriterion("BANK_AC_NAME between", value1, value2, "bankAcName");
            return (Criteria) this;
        }

        public Criteria andBankAcNameNotBetween(Object value1, Object value2) {
            addCriterion("BANK_AC_NAME not between", value1, value2, "bankAcName");
            return (Criteria) this;
        }

        public Criteria andRemarksIsNull() {
            addCriterion("REMARKS is null");
            return (Criteria) this;
        }

        public Criteria andRemarksIsNotNull() {
            addCriterion("REMARKS is not null");
            return (Criteria) this;
        }

        public Criteria andRemarksEqualTo(Object value) {
            addCriterion("REMARKS =", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotEqualTo(Object value) {
            addCriterion("REMARKS <>", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksGreaterThan(Object value) {
            addCriterion("REMARKS >", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksGreaterThanOrEqualTo(Object value) {
            addCriterion("REMARKS >=", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLessThan(Object value) {
            addCriterion("REMARKS <", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLessThanOrEqualTo(Object value) {
            addCriterion("REMARKS <=", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksIn(List<Object> values) {
            addCriterion("REMARKS in", values, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotIn(List<Object> values) {
            addCriterion("REMARKS not in", values, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksBetween(Object value1, Object value2) {
            addCriterion("REMARKS between", value1, value2, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotBetween(Object value1, Object value2) {
            addCriterion("REMARKS not between", value1, value2, "remarks");
            return (Criteria) this;
        }

        public Criteria andBankNameIsNull() {
            addCriterion("BANK_NAME is null");
            return (Criteria) this;
        }

        public Criteria andBankNameIsNotNull() {
            addCriterion("BANK_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andBankNameEqualTo(Object value) {
            addCriterion("BANK_NAME =", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameNotEqualTo(Object value) {
            addCriterion("BANK_NAME <>", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameGreaterThan(Object value) {
            addCriterion("BANK_NAME >", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameGreaterThanOrEqualTo(Object value) {
            addCriterion("BANK_NAME >=", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameLessThan(Object value) {
            addCriterion("BANK_NAME <", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameLessThanOrEqualTo(Object value) {
            addCriterion("BANK_NAME <=", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameIn(List<Object> values) {
            addCriterion("BANK_NAME in", values, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameNotIn(List<Object> values) {
            addCriterion("BANK_NAME not in", values, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameBetween(Object value1, Object value2) {
            addCriterion("BANK_NAME between", value1, value2, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameNotBetween(Object value1, Object value2) {
            addCriterion("BANK_NAME not between", value1, value2, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankAddressIsNull() {
            addCriterion("BANK_ADDRESS is null");
            return (Criteria) this;
        }

        public Criteria andBankAddressIsNotNull() {
            addCriterion("BANK_ADDRESS is not null");
            return (Criteria) this;
        }

        public Criteria andBankAddressEqualTo(Object value) {
            addCriterion("BANK_ADDRESS =", value, "bankAddress");
            return (Criteria) this;
        }

        public Criteria andBankAddressNotEqualTo(Object value) {
            addCriterion("BANK_ADDRESS <>", value, "bankAddress");
            return (Criteria) this;
        }

        public Criteria andBankAddressGreaterThan(Object value) {
            addCriterion("BANK_ADDRESS >", value, "bankAddress");
            return (Criteria) this;
        }

        public Criteria andBankAddressGreaterThanOrEqualTo(Object value) {
            addCriterion("BANK_ADDRESS >=", value, "bankAddress");
            return (Criteria) this;
        }

        public Criteria andBankAddressLessThan(Object value) {
            addCriterion("BANK_ADDRESS <", value, "bankAddress");
            return (Criteria) this;
        }

        public Criteria andBankAddressLessThanOrEqualTo(Object value) {
            addCriterion("BANK_ADDRESS <=", value, "bankAddress");
            return (Criteria) this;
        }

        public Criteria andBankAddressIn(List<Object> values) {
            addCriterion("BANK_ADDRESS in", values, "bankAddress");
            return (Criteria) this;
        }

        public Criteria andBankAddressNotIn(List<Object> values) {
            addCriterion("BANK_ADDRESS not in", values, "bankAddress");
            return (Criteria) this;
        }

        public Criteria andBankAddressBetween(Object value1, Object value2) {
            addCriterion("BANK_ADDRESS between", value1, value2, "bankAddress");
            return (Criteria) this;
        }

        public Criteria andBankAddressNotBetween(Object value1, Object value2) {
            addCriterion("BANK_ADDRESS not between", value1, value2, "bankAddress");
            return (Criteria) this;
        }

        public Criteria andBankStateIsNull() {
            addCriterion("BANK_STATE is null");
            return (Criteria) this;
        }

        public Criteria andBankStateIsNotNull() {
            addCriterion("BANK_STATE is not null");
            return (Criteria) this;
        }

        public Criteria andBankStateEqualTo(Object value) {
            addCriterion("BANK_STATE =", value, "bankState");
            return (Criteria) this;
        }

        public Criteria andBankStateNotEqualTo(Object value) {
            addCriterion("BANK_STATE <>", value, "bankState");
            return (Criteria) this;
        }

        public Criteria andBankStateGreaterThan(Object value) {
            addCriterion("BANK_STATE >", value, "bankState");
            return (Criteria) this;
        }

        public Criteria andBankStateGreaterThanOrEqualTo(Object value) {
            addCriterion("BANK_STATE >=", value, "bankState");
            return (Criteria) this;
        }

        public Criteria andBankStateLessThan(Object value) {
            addCriterion("BANK_STATE <", value, "bankState");
            return (Criteria) this;
        }

        public Criteria andBankStateLessThanOrEqualTo(Object value) {
            addCriterion("BANK_STATE <=", value, "bankState");
            return (Criteria) this;
        }

        public Criteria andBankStateIn(List<Object> values) {
            addCriterion("BANK_STATE in", values, "bankState");
            return (Criteria) this;
        }

        public Criteria andBankStateNotIn(List<Object> values) {
            addCriterion("BANK_STATE not in", values, "bankState");
            return (Criteria) this;
        }

        public Criteria andBankStateBetween(Object value1, Object value2) {
            addCriterion("BANK_STATE between", value1, value2, "bankState");
            return (Criteria) this;
        }

        public Criteria andBankStateNotBetween(Object value1, Object value2) {
            addCriterion("BANK_STATE not between", value1, value2, "bankState");
            return (Criteria) this;
        }

        public Criteria andBankPoscodeIsNull() {
            addCriterion("BANK_POSCODE is null");
            return (Criteria) this;
        }

        public Criteria andBankPoscodeIsNotNull() {
            addCriterion("BANK_POSCODE is not null");
            return (Criteria) this;
        }

        public Criteria andBankPoscodeEqualTo(String value) {
            addCriterion("BANK_POSCODE =", value, "bankPoscode");
            return (Criteria) this;
        }

        public Criteria andBankPoscodeNotEqualTo(String value) {
            addCriterion("BANK_POSCODE <>", value, "bankPoscode");
            return (Criteria) this;
        }

        public Criteria andBankPoscodeGreaterThan(String value) {
            addCriterion("BANK_POSCODE >", value, "bankPoscode");
            return (Criteria) this;
        }

        public Criteria andBankPoscodeGreaterThanOrEqualTo(String value) {
            addCriterion("BANK_POSCODE >=", value, "bankPoscode");
            return (Criteria) this;
        }

        public Criteria andBankPoscodeLessThan(String value) {
            addCriterion("BANK_POSCODE <", value, "bankPoscode");
            return (Criteria) this;
        }

        public Criteria andBankPoscodeLessThanOrEqualTo(String value) {
            addCriterion("BANK_POSCODE <=", value, "bankPoscode");
            return (Criteria) this;
        }

        public Criteria andBankPoscodeLike(String value) {
            addCriterion("BANK_POSCODE like", value, "bankPoscode");
            return (Criteria) this;
        }

        public Criteria andBankPoscodeNotLike(String value) {
            addCriterion("BANK_POSCODE not like", value, "bankPoscode");
            return (Criteria) this;
        }

        public Criteria andBankPoscodeIn(List<String> values) {
            addCriterion("BANK_POSCODE in", values, "bankPoscode");
            return (Criteria) this;
        }

        public Criteria andBankPoscodeNotIn(List<String> values) {
            addCriterion("BANK_POSCODE not in", values, "bankPoscode");
            return (Criteria) this;
        }

        public Criteria andBankPoscodeBetween(String value1, String value2) {
            addCriterion("BANK_POSCODE between", value1, value2, "bankPoscode");
            return (Criteria) this;
        }

        public Criteria andBankPoscodeNotBetween(String value1, String value2) {
            addCriterion("BANK_POSCODE not between", value1, value2, "bankPoscode");
            return (Criteria) this;
        }

        public Criteria andBankCityIsNull() {
            addCriterion("BANK_CITY is null");
            return (Criteria) this;
        }

        public Criteria andBankCityIsNotNull() {
            addCriterion("BANK_CITY is not null");
            return (Criteria) this;
        }

        public Criteria andBankCityEqualTo(Object value) {
            addCriterion("BANK_CITY =", value, "bankCity");
            return (Criteria) this;
        }

        public Criteria andBankCityNotEqualTo(Object value) {
            addCriterion("BANK_CITY <>", value, "bankCity");
            return (Criteria) this;
        }

        public Criteria andBankCityGreaterThan(Object value) {
            addCriterion("BANK_CITY >", value, "bankCity");
            return (Criteria) this;
        }

        public Criteria andBankCityGreaterThanOrEqualTo(Object value) {
            addCriterion("BANK_CITY >=", value, "bankCity");
            return (Criteria) this;
        }

        public Criteria andBankCityLessThan(Object value) {
            addCriterion("BANK_CITY <", value, "bankCity");
            return (Criteria) this;
        }

        public Criteria andBankCityLessThanOrEqualTo(Object value) {
            addCriterion("BANK_CITY <=", value, "bankCity");
            return (Criteria) this;
        }

        public Criteria andBankCityIn(List<Object> values) {
            addCriterion("BANK_CITY in", values, "bankCity");
            return (Criteria) this;
        }

        public Criteria andBankCityNotIn(List<Object> values) {
            addCriterion("BANK_CITY not in", values, "bankCity");
            return (Criteria) this;
        }

        public Criteria andBankCityBetween(Object value1, Object value2) {
            addCriterion("BANK_CITY between", value1, value2, "bankCity");
            return (Criteria) this;
        }

        public Criteria andBankCityNotBetween(Object value1, Object value2) {
            addCriterion("BANK_CITY not between", value1, value2, "bankCity");
            return (Criteria) this;
        }

        public Criteria andTestDateIsNull() {
            addCriterion("TEST_DATE is null");
            return (Criteria) this;
        }

        public Criteria andTestDateIsNotNull() {
            addCriterion("TEST_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andTestDateEqualTo(Date value) {
            addCriterion("TEST_DATE =", value, "testDate");
            return (Criteria) this;
        }

        public Criteria andTestDateNotEqualTo(Date value) {
            addCriterion("TEST_DATE <>", value, "testDate");
            return (Criteria) this;
        }

        public Criteria andTestDateGreaterThan(Date value) {
            addCriterion("TEST_DATE >", value, "testDate");
            return (Criteria) this;
        }

        public Criteria andTestDateGreaterThanOrEqualTo(Date value) {
            addCriterion("TEST_DATE >=", value, "testDate");
            return (Criteria) this;
        }

        public Criteria andTestDateLessThan(Date value) {
            addCriterion("TEST_DATE <", value, "testDate");
            return (Criteria) this;
        }

        public Criteria andTestDateLessThanOrEqualTo(Date value) {
            addCriterion("TEST_DATE <=", value, "testDate");
            return (Criteria) this;
        }

        public Criteria andTestDateIn(List<Date> values) {
            addCriterion("TEST_DATE in", values, "testDate");
            return (Criteria) this;
        }

        public Criteria andTestDateNotIn(List<Date> values) {
            addCriterion("TEST_DATE not in", values, "testDate");
            return (Criteria) this;
        }

        public Criteria andTestDateBetween(Date value1, Date value2) {
            addCriterion("TEST_DATE between", value1, value2, "testDate");
            return (Criteria) this;
        }

        public Criteria andTestDateNotBetween(Date value1, Date value2) {
            addCriterion("TEST_DATE not between", value1, value2, "testDate");
            return (Criteria) this;
        }

        public Criteria andTrainingByIsNull() {
            addCriterion("TRAINING_BY is null");
            return (Criteria) this;
        }

        public Criteria andTrainingByIsNotNull() {
            addCriterion("TRAINING_BY is not null");
            return (Criteria) this;
        }

        public Criteria andTrainingByEqualTo(String value) {
            addCriterion("TRAINING_BY =", value, "trainingBy");
            return (Criteria) this;
        }

        public Criteria andTrainingByNotEqualTo(String value) {
            addCriterion("TRAINING_BY <>", value, "trainingBy");
            return (Criteria) this;
        }

        public Criteria andTrainingByGreaterThan(String value) {
            addCriterion("TRAINING_BY >", value, "trainingBy");
            return (Criteria) this;
        }

        public Criteria andTrainingByGreaterThanOrEqualTo(String value) {
            addCriterion("TRAINING_BY >=", value, "trainingBy");
            return (Criteria) this;
        }

        public Criteria andTrainingByLessThan(String value) {
            addCriterion("TRAINING_BY <", value, "trainingBy");
            return (Criteria) this;
        }

        public Criteria andTrainingByLessThanOrEqualTo(String value) {
            addCriterion("TRAINING_BY <=", value, "trainingBy");
            return (Criteria) this;
        }

        public Criteria andTrainingByLike(String value) {
            addCriterion("TRAINING_BY like", value, "trainingBy");
            return (Criteria) this;
        }

        public Criteria andTrainingByNotLike(String value) {
            addCriterion("TRAINING_BY not like", value, "trainingBy");
            return (Criteria) this;
        }

        public Criteria andTrainingByIn(List<String> values) {
            addCriterion("TRAINING_BY in", values, "trainingBy");
            return (Criteria) this;
        }

        public Criteria andTrainingByNotIn(List<String> values) {
            addCriterion("TRAINING_BY not in", values, "trainingBy");
            return (Criteria) this;
        }

        public Criteria andTrainingByBetween(String value1, String value2) {
            addCriterion("TRAINING_BY between", value1, value2, "trainingBy");
            return (Criteria) this;
        }

        public Criteria andTrainingByNotBetween(String value1, String value2) {
            addCriterion("TRAINING_BY not between", value1, value2, "trainingBy");
            return (Criteria) this;
        }

        public Criteria andHardCopyIsNull() {
            addCriterion("HARD_COPY is null");
            return (Criteria) this;
        }

        public Criteria andHardCopyIsNotNull() {
            addCriterion("HARD_COPY is not null");
            return (Criteria) this;
        }

        public Criteria andHardCopyEqualTo(String value) {
            addCriterion("HARD_COPY =", value, "hardCopy");
            return (Criteria) this;
        }

        public Criteria andHardCopyNotEqualTo(String value) {
            addCriterion("HARD_COPY <>", value, "hardCopy");
            return (Criteria) this;
        }

        public Criteria andHardCopyGreaterThan(String value) {
            addCriterion("HARD_COPY >", value, "hardCopy");
            return (Criteria) this;
        }

        public Criteria andHardCopyGreaterThanOrEqualTo(String value) {
            addCriterion("HARD_COPY >=", value, "hardCopy");
            return (Criteria) this;
        }

        public Criteria andHardCopyLessThan(String value) {
            addCriterion("HARD_COPY <", value, "hardCopy");
            return (Criteria) this;
        }

        public Criteria andHardCopyLessThanOrEqualTo(String value) {
            addCriterion("HARD_COPY <=", value, "hardCopy");
            return (Criteria) this;
        }

        public Criteria andHardCopyLike(String value) {
            addCriterion("HARD_COPY like", value, "hardCopy");
            return (Criteria) this;
        }

        public Criteria andHardCopyNotLike(String value) {
            addCriterion("HARD_COPY not like", value, "hardCopy");
            return (Criteria) this;
        }

        public Criteria andHardCopyIn(List<String> values) {
            addCriterion("HARD_COPY in", values, "hardCopy");
            return (Criteria) this;
        }

        public Criteria andHardCopyNotIn(List<String> values) {
            addCriterion("HARD_COPY not in", values, "hardCopy");
            return (Criteria) this;
        }

        public Criteria andHardCopyBetween(String value1, String value2) {
            addCriterion("HARD_COPY between", value1, value2, "hardCopy");
            return (Criteria) this;
        }

        public Criteria andHardCopyNotBetween(String value1, String value2) {
            addCriterion("HARD_COPY not between", value1, value2, "hardCopy");
            return (Criteria) this;
        }

        public Criteria andTrainingIsNull() {
            addCriterion("TRAINING is null");
            return (Criteria) this;
        }

        public Criteria andTrainingIsNotNull() {
            addCriterion("TRAINING is not null");
            return (Criteria) this;
        }

        public Criteria andTrainingEqualTo(String value) {
            addCriterion("TRAINING =", value, "training");
            return (Criteria) this;
        }

        public Criteria andTrainingNotEqualTo(String value) {
            addCriterion("TRAINING <>", value, "training");
            return (Criteria) this;
        }

        public Criteria andTrainingGreaterThan(String value) {
            addCriterion("TRAINING >", value, "training");
            return (Criteria) this;
        }

        public Criteria andTrainingGreaterThanOrEqualTo(String value) {
            addCriterion("TRAINING >=", value, "training");
            return (Criteria) this;
        }

        public Criteria andTrainingLessThan(String value) {
            addCriterion("TRAINING <", value, "training");
            return (Criteria) this;
        }

        public Criteria andTrainingLessThanOrEqualTo(String value) {
            addCriterion("TRAINING <=", value, "training");
            return (Criteria) this;
        }

        public Criteria andTrainingLike(String value) {
            addCriterion("TRAINING like", value, "training");
            return (Criteria) this;
        }

        public Criteria andTrainingNotLike(String value) {
            addCriterion("TRAINING not like", value, "training");
            return (Criteria) this;
        }

        public Criteria andTrainingIn(List<String> values) {
            addCriterion("TRAINING in", values, "training");
            return (Criteria) this;
        }

        public Criteria andTrainingNotIn(List<String> values) {
            addCriterion("TRAINING not in", values, "training");
            return (Criteria) this;
        }

        public Criteria andTrainingBetween(String value1, String value2) {
            addCriterion("TRAINING between", value1, value2, "training");
            return (Criteria) this;
        }

        public Criteria andTrainingNotBetween(String value1, String value2) {
            addCriterion("TRAINING not between", value1, value2, "training");
            return (Criteria) this;
        }

        public Criteria andTestCardIsNull() {
            addCriterion("TEST_CARD is null");
            return (Criteria) this;
        }

        public Criteria andTestCardIsNotNull() {
            addCriterion("TEST_CARD is not null");
            return (Criteria) this;
        }

        public Criteria andTestCardEqualTo(String value) {
            addCriterion("TEST_CARD =", value, "testCard");
            return (Criteria) this;
        }

        public Criteria andTestCardNotEqualTo(String value) {
            addCriterion("TEST_CARD <>", value, "testCard");
            return (Criteria) this;
        }

        public Criteria andTestCardGreaterThan(String value) {
            addCriterion("TEST_CARD >", value, "testCard");
            return (Criteria) this;
        }

        public Criteria andTestCardGreaterThanOrEqualTo(String value) {
            addCriterion("TEST_CARD >=", value, "testCard");
            return (Criteria) this;
        }

        public Criteria andTestCardLessThan(String value) {
            addCriterion("TEST_CARD <", value, "testCard");
            return (Criteria) this;
        }

        public Criteria andTestCardLessThanOrEqualTo(String value) {
            addCriterion("TEST_CARD <=", value, "testCard");
            return (Criteria) this;
        }

        public Criteria andTestCardLike(String value) {
            addCriterion("TEST_CARD like", value, "testCard");
            return (Criteria) this;
        }

        public Criteria andTestCardNotLike(String value) {
            addCriterion("TEST_CARD not like", value, "testCard");
            return (Criteria) this;
        }

        public Criteria andTestCardIn(List<String> values) {
            addCriterion("TEST_CARD in", values, "testCard");
            return (Criteria) this;
        }

        public Criteria andTestCardNotIn(List<String> values) {
            addCriterion("TEST_CARD not in", values, "testCard");
            return (Criteria) this;
        }

        public Criteria andTestCardBetween(String value1, String value2) {
            addCriterion("TEST_CARD between", value1, value2, "testCard");
            return (Criteria) this;
        }

        public Criteria andTestCardNotBetween(String value1, String value2) {
            addCriterion("TEST_CARD not between", value1, value2, "testCard");
            return (Criteria) this;
        }

        public Criteria andActivationDateIsNull() {
            addCriterion("ACTIVATION_DATE is null");
            return (Criteria) this;
        }

        public Criteria andActivationDateIsNotNull() {
            addCriterion("ACTIVATION_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andActivationDateEqualTo(Date value) {
            addCriterion("ACTIVATION_DATE =", value, "activationDate");
            return (Criteria) this;
        }

        public Criteria andActivationDateNotEqualTo(Date value) {
            addCriterion("ACTIVATION_DATE <>", value, "activationDate");
            return (Criteria) this;
        }

        public Criteria andActivationDateGreaterThan(Date value) {
            addCriterion("ACTIVATION_DATE >", value, "activationDate");
            return (Criteria) this;
        }

        public Criteria andActivationDateGreaterThanOrEqualTo(Date value) {
            addCriterion("ACTIVATION_DATE >=", value, "activationDate");
            return (Criteria) this;
        }

        public Criteria andActivationDateLessThan(Date value) {
            addCriterion("ACTIVATION_DATE <", value, "activationDate");
            return (Criteria) this;
        }

        public Criteria andActivationDateLessThanOrEqualTo(Date value) {
            addCriterion("ACTIVATION_DATE <=", value, "activationDate");
            return (Criteria) this;
        }

        public Criteria andActivationDateIn(List<Date> values) {
            addCriterion("ACTIVATION_DATE in", values, "activationDate");
            return (Criteria) this;
        }

        public Criteria andActivationDateNotIn(List<Date> values) {
            addCriterion("ACTIVATION_DATE not in", values, "activationDate");
            return (Criteria) this;
        }

        public Criteria andActivationDateBetween(Date value1, Date value2) {
            addCriterion("ACTIVATION_DATE between", value1, value2, "activationDate");
            return (Criteria) this;
        }

        public Criteria andActivationDateNotBetween(Date value1, Date value2) {
            addCriterion("ACTIVATION_DATE not between", value1, value2, "activationDate");
            return (Criteria) this;
        }

        public Criteria andCancellationDateIsNull() {
            addCriterion("CANCELLATION_DATE is null");
            return (Criteria) this;
        }

        public Criteria andCancellationDateIsNotNull() {
            addCriterion("CANCELLATION_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andCancellationDateEqualTo(Date value) {
            addCriterion("CANCELLATION_DATE =", value, "cancellationDate");
            return (Criteria) this;
        }

        public Criteria andCancellationDateNotEqualTo(Date value) {
            addCriterion("CANCELLATION_DATE <>", value, "cancellationDate");
            return (Criteria) this;
        }

        public Criteria andCancellationDateGreaterThan(Date value) {
            addCriterion("CANCELLATION_DATE >", value, "cancellationDate");
            return (Criteria) this;
        }

        public Criteria andCancellationDateGreaterThanOrEqualTo(Date value) {
            addCriterion("CANCELLATION_DATE >=", value, "cancellationDate");
            return (Criteria) this;
        }

        public Criteria andCancellationDateLessThan(Date value) {
            addCriterion("CANCELLATION_DATE <", value, "cancellationDate");
            return (Criteria) this;
        }

        public Criteria andCancellationDateLessThanOrEqualTo(Date value) {
            addCriterion("CANCELLATION_DATE <=", value, "cancellationDate");
            return (Criteria) this;
        }

        public Criteria andCancellationDateIn(List<Date> values) {
            addCriterion("CANCELLATION_DATE in", values, "cancellationDate");
            return (Criteria) this;
        }

        public Criteria andCancellationDateNotIn(List<Date> values) {
            addCriterion("CANCELLATION_DATE not in", values, "cancellationDate");
            return (Criteria) this;
        }

        public Criteria andCancellationDateBetween(Date value1, Date value2) {
            addCriterion("CANCELLATION_DATE between", value1, value2, "cancellationDate");
            return (Criteria) this;
        }

        public Criteria andCancellationDateNotBetween(Date value1, Date value2) {
            addCriterion("CANCELLATION_DATE not between", value1, value2, "cancellationDate");
            return (Criteria) this;
        }

        public Criteria andBillingAddressIsNull() {
            addCriterion("BILLING_ADDRESS is null");
            return (Criteria) this;
        }

        public Criteria andBillingAddressIsNotNull() {
            addCriterion("BILLING_ADDRESS is not null");
            return (Criteria) this;
        }

        public Criteria andBillingAddressEqualTo(String value) {
            addCriterion("BILLING_ADDRESS =", value, "billingAddress");
            return (Criteria) this;
        }

        public Criteria andBillingAddressNotEqualTo(String value) {
            addCriterion("BILLING_ADDRESS <>", value, "billingAddress");
            return (Criteria) this;
        }

        public Criteria andBillingAddressGreaterThan(String value) {
            addCriterion("BILLING_ADDRESS >", value, "billingAddress");
            return (Criteria) this;
        }

        public Criteria andBillingAddressGreaterThanOrEqualTo(String value) {
            addCriterion("BILLING_ADDRESS >=", value, "billingAddress");
            return (Criteria) this;
        }

        public Criteria andBillingAddressLessThan(String value) {
            addCriterion("BILLING_ADDRESS <", value, "billingAddress");
            return (Criteria) this;
        }

        public Criteria andBillingAddressLessThanOrEqualTo(String value) {
            addCriterion("BILLING_ADDRESS <=", value, "billingAddress");
            return (Criteria) this;
        }

        public Criteria andBillingAddressLike(String value) {
            addCriterion("BILLING_ADDRESS like", value, "billingAddress");
            return (Criteria) this;
        }

        public Criteria andBillingAddressNotLike(String value) {
            addCriterion("BILLING_ADDRESS not like", value, "billingAddress");
            return (Criteria) this;
        }

        public Criteria andBillingAddressIn(List<String> values) {
            addCriterion("BILLING_ADDRESS in", values, "billingAddress");
            return (Criteria) this;
        }

        public Criteria andBillingAddressNotIn(List<String> values) {
            addCriterion("BILLING_ADDRESS not in", values, "billingAddress");
            return (Criteria) this;
        }

        public Criteria andBillingAddressBetween(String value1, String value2) {
            addCriterion("BILLING_ADDRESS between", value1, value2, "billingAddress");
            return (Criteria) this;
        }

        public Criteria andBillingAddressNotBetween(String value1, String value2) {
            addCriterion("BILLING_ADDRESS not between", value1, value2, "billingAddress");
            return (Criteria) this;
        }

        public Criteria andBillingPostcodeIsNull() {
            addCriterion("BILLING_POSTCODE is null");
            return (Criteria) this;
        }

        public Criteria andBillingPostcodeIsNotNull() {
            addCriterion("BILLING_POSTCODE is not null");
            return (Criteria) this;
        }

        public Criteria andBillingPostcodeEqualTo(String value) {
            addCriterion("BILLING_POSTCODE =", value, "billingPostcode");
            return (Criteria) this;
        }

        public Criteria andBillingPostcodeNotEqualTo(String value) {
            addCriterion("BILLING_POSTCODE <>", value, "billingPostcode");
            return (Criteria) this;
        }

        public Criteria andBillingPostcodeGreaterThan(String value) {
            addCriterion("BILLING_POSTCODE >", value, "billingPostcode");
            return (Criteria) this;
        }

        public Criteria andBillingPostcodeGreaterThanOrEqualTo(String value) {
            addCriterion("BILLING_POSTCODE >=", value, "billingPostcode");
            return (Criteria) this;
        }

        public Criteria andBillingPostcodeLessThan(String value) {
            addCriterion("BILLING_POSTCODE <", value, "billingPostcode");
            return (Criteria) this;
        }

        public Criteria andBillingPostcodeLessThanOrEqualTo(String value) {
            addCriterion("BILLING_POSTCODE <=", value, "billingPostcode");
            return (Criteria) this;
        }

        public Criteria andBillingPostcodeLike(String value) {
            addCriterion("BILLING_POSTCODE like", value, "billingPostcode");
            return (Criteria) this;
        }

        public Criteria andBillingPostcodeNotLike(String value) {
            addCriterion("BILLING_POSTCODE not like", value, "billingPostcode");
            return (Criteria) this;
        }

        public Criteria andBillingPostcodeIn(List<String> values) {
            addCriterion("BILLING_POSTCODE in", values, "billingPostcode");
            return (Criteria) this;
        }

        public Criteria andBillingPostcodeNotIn(List<String> values) {
            addCriterion("BILLING_POSTCODE not in", values, "billingPostcode");
            return (Criteria) this;
        }

        public Criteria andBillingPostcodeBetween(String value1, String value2) {
            addCriterion("BILLING_POSTCODE between", value1, value2, "billingPostcode");
            return (Criteria) this;
        }

        public Criteria andBillingPostcodeNotBetween(String value1, String value2) {
            addCriterion("BILLING_POSTCODE not between", value1, value2, "billingPostcode");
            return (Criteria) this;
        }

        public Criteria andBillingCityIsNull() {
            addCriterion("BILLING_CITY is null");
            return (Criteria) this;
        }

        public Criteria andBillingCityIsNotNull() {
            addCriterion("BILLING_CITY is not null");
            return (Criteria) this;
        }

        public Criteria andBillingCityEqualTo(String value) {
            addCriterion("BILLING_CITY =", value, "billingCity");
            return (Criteria) this;
        }

        public Criteria andBillingCityNotEqualTo(String value) {
            addCriterion("BILLING_CITY <>", value, "billingCity");
            return (Criteria) this;
        }

        public Criteria andBillingCityGreaterThan(String value) {
            addCriterion("BILLING_CITY >", value, "billingCity");
            return (Criteria) this;
        }

        public Criteria andBillingCityGreaterThanOrEqualTo(String value) {
            addCriterion("BILLING_CITY >=", value, "billingCity");
            return (Criteria) this;
        }

        public Criteria andBillingCityLessThan(String value) {
            addCriterion("BILLING_CITY <", value, "billingCity");
            return (Criteria) this;
        }

        public Criteria andBillingCityLessThanOrEqualTo(String value) {
            addCriterion("BILLING_CITY <=", value, "billingCity");
            return (Criteria) this;
        }

        public Criteria andBillingCityLike(String value) {
            addCriterion("BILLING_CITY like", value, "billingCity");
            return (Criteria) this;
        }

        public Criteria andBillingCityNotLike(String value) {
            addCriterion("BILLING_CITY not like", value, "billingCity");
            return (Criteria) this;
        }

        public Criteria andBillingCityIn(List<String> values) {
            addCriterion("BILLING_CITY in", values, "billingCity");
            return (Criteria) this;
        }

        public Criteria andBillingCityNotIn(List<String> values) {
            addCriterion("BILLING_CITY not in", values, "billingCity");
            return (Criteria) this;
        }

        public Criteria andBillingCityBetween(String value1, String value2) {
            addCriterion("BILLING_CITY between", value1, value2, "billingCity");
            return (Criteria) this;
        }

        public Criteria andBillingCityNotBetween(String value1, String value2) {
            addCriterion("BILLING_CITY not between", value1, value2, "billingCity");
            return (Criteria) this;
        }

        public Criteria andBillingStateIsNull() {
            addCriterion("BILLING_STATE is null");
            return (Criteria) this;
        }

        public Criteria andBillingStateIsNotNull() {
            addCriterion("BILLING_STATE is not null");
            return (Criteria) this;
        }

        public Criteria andBillingStateEqualTo(String value) {
            addCriterion("BILLING_STATE =", value, "billingState");
            return (Criteria) this;
        }

        public Criteria andBillingStateNotEqualTo(String value) {
            addCriterion("BILLING_STATE <>", value, "billingState");
            return (Criteria) this;
        }

        public Criteria andBillingStateGreaterThan(String value) {
            addCriterion("BILLING_STATE >", value, "billingState");
            return (Criteria) this;
        }

        public Criteria andBillingStateGreaterThanOrEqualTo(String value) {
            addCriterion("BILLING_STATE >=", value, "billingState");
            return (Criteria) this;
        }

        public Criteria andBillingStateLessThan(String value) {
            addCriterion("BILLING_STATE <", value, "billingState");
            return (Criteria) this;
        }

        public Criteria andBillingStateLessThanOrEqualTo(String value) {
            addCriterion("BILLING_STATE <=", value, "billingState");
            return (Criteria) this;
        }

        public Criteria andBillingStateLike(String value) {
            addCriterion("BILLING_STATE like", value, "billingState");
            return (Criteria) this;
        }

        public Criteria andBillingStateNotLike(String value) {
            addCriterion("BILLING_STATE not like", value, "billingState");
            return (Criteria) this;
        }

        public Criteria andBillingStateIn(List<String> values) {
            addCriterion("BILLING_STATE in", values, "billingState");
            return (Criteria) this;
        }

        public Criteria andBillingStateNotIn(List<String> values) {
            addCriterion("BILLING_STATE not in", values, "billingState");
            return (Criteria) this;
        }

        public Criteria andBillingStateBetween(String value1, String value2) {
            addCriterion("BILLING_STATE between", value1, value2, "billingState");
            return (Criteria) this;
        }

        public Criteria andBillingStateNotBetween(String value1, String value2) {
            addCriterion("BILLING_STATE not between", value1, value2, "billingState");
            return (Criteria) this;
        }

        public Criteria andDbcdIsNull() {
            addCriterion("DBCD is null");
            return (Criteria) this;
        }

        public Criteria andDbcdIsNotNull() {
            addCriterion("DBCD is not null");
            return (Criteria) this;
        }

        public Criteria andDbcdEqualTo(String value) {
            addCriterion("DBCD =", value, "dbcd");
            return (Criteria) this;
        }

        public Criteria andDbcdNotEqualTo(String value) {
            addCriterion("DBCD <>", value, "dbcd");
            return (Criteria) this;
        }

        public Criteria andDbcdGreaterThan(String value) {
            addCriterion("DBCD >", value, "dbcd");
            return (Criteria) this;
        }

        public Criteria andDbcdGreaterThanOrEqualTo(String value) {
            addCriterion("DBCD >=", value, "dbcd");
            return (Criteria) this;
        }

        public Criteria andDbcdLessThan(String value) {
            addCriterion("DBCD <", value, "dbcd");
            return (Criteria) this;
        }

        public Criteria andDbcdLessThanOrEqualTo(String value) {
            addCriterion("DBCD <=", value, "dbcd");
            return (Criteria) this;
        }

        public Criteria andDbcdLike(String value) {
            addCriterion("DBCD like", value, "dbcd");
            return (Criteria) this;
        }

        public Criteria andDbcdNotLike(String value) {
            addCriterion("DBCD not like", value, "dbcd");
            return (Criteria) this;
        }

        public Criteria andDbcdIn(List<String> values) {
            addCriterion("DBCD in", values, "dbcd");
            return (Criteria) this;
        }

        public Criteria andDbcdNotIn(List<String> values) {
            addCriterion("DBCD not in", values, "dbcd");
            return (Criteria) this;
        }

        public Criteria andDbcdBetween(String value1, String value2) {
            addCriterion("DBCD between", value1, value2, "dbcd");
            return (Criteria) this;
        }

        public Criteria andDbcdNotBetween(String value1, String value2) {
            addCriterion("DBCD not between", value1, value2, "dbcd");
            return (Criteria) this;
        }

        public Criteria andDeliveryModeIsNull() {
            addCriterion("DELIVERY_MODE is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryModeIsNotNull() {
            addCriterion("DELIVERY_MODE is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryModeEqualTo(String value) {
            addCriterion("DELIVERY_MODE =", value, "deliveryMode");
            return (Criteria) this;
        }

        public Criteria andDeliveryModeNotEqualTo(String value) {
            addCriterion("DELIVERY_MODE <>", value, "deliveryMode");
            return (Criteria) this;
        }

        public Criteria andDeliveryModeGreaterThan(String value) {
            addCriterion("DELIVERY_MODE >", value, "deliveryMode");
            return (Criteria) this;
        }

        public Criteria andDeliveryModeGreaterThanOrEqualTo(String value) {
            addCriterion("DELIVERY_MODE >=", value, "deliveryMode");
            return (Criteria) this;
        }

        public Criteria andDeliveryModeLessThan(String value) {
            addCriterion("DELIVERY_MODE <", value, "deliveryMode");
            return (Criteria) this;
        }

        public Criteria andDeliveryModeLessThanOrEqualTo(String value) {
            addCriterion("DELIVERY_MODE <=", value, "deliveryMode");
            return (Criteria) this;
        }

        public Criteria andDeliveryModeLike(String value) {
            addCriterion("DELIVERY_MODE like", value, "deliveryMode");
            return (Criteria) this;
        }

        public Criteria andDeliveryModeNotLike(String value) {
            addCriterion("DELIVERY_MODE not like", value, "deliveryMode");
            return (Criteria) this;
        }

        public Criteria andDeliveryModeIn(List<String> values) {
            addCriterion("DELIVERY_MODE in", values, "deliveryMode");
            return (Criteria) this;
        }

        public Criteria andDeliveryModeNotIn(List<String> values) {
            addCriterion("DELIVERY_MODE not in", values, "deliveryMode");
            return (Criteria) this;
        }

        public Criteria andDeliveryModeBetween(String value1, String value2) {
            addCriterion("DELIVERY_MODE between", value1, value2, "deliveryMode");
            return (Criteria) this;
        }

        public Criteria andDeliveryModeNotBetween(String value1, String value2) {
            addCriterion("DELIVERY_MODE not between", value1, value2, "deliveryMode");
            return (Criteria) this;
        }

        public Criteria andProviderRefnoIsNull() {
            addCriterion("PROVIDER_REFNO is null");
            return (Criteria) this;
        }

        public Criteria andProviderRefnoIsNotNull() {
            addCriterion("PROVIDER_REFNO is not null");
            return (Criteria) this;
        }

        public Criteria andProviderRefnoEqualTo(String value) {
            addCriterion("PROVIDER_REFNO =", value, "providerRefno");
            return (Criteria) this;
        }

        public Criteria andProviderRefnoNotEqualTo(String value) {
            addCriterion("PROVIDER_REFNO <>", value, "providerRefno");
            return (Criteria) this;
        }

        public Criteria andProviderRefnoGreaterThan(String value) {
            addCriterion("PROVIDER_REFNO >", value, "providerRefno");
            return (Criteria) this;
        }

        public Criteria andProviderRefnoGreaterThanOrEqualTo(String value) {
            addCriterion("PROVIDER_REFNO >=", value, "providerRefno");
            return (Criteria) this;
        }

        public Criteria andProviderRefnoLessThan(String value) {
            addCriterion("PROVIDER_REFNO <", value, "providerRefno");
            return (Criteria) this;
        }

        public Criteria andProviderRefnoLessThanOrEqualTo(String value) {
            addCriterion("PROVIDER_REFNO <=", value, "providerRefno");
            return (Criteria) this;
        }

        public Criteria andProviderRefnoLike(String value) {
            addCriterion("PROVIDER_REFNO like", value, "providerRefno");
            return (Criteria) this;
        }

        public Criteria andProviderRefnoNotLike(String value) {
            addCriterion("PROVIDER_REFNO not like", value, "providerRefno");
            return (Criteria) this;
        }

        public Criteria andProviderRefnoIn(List<String> values) {
            addCriterion("PROVIDER_REFNO in", values, "providerRefno");
            return (Criteria) this;
        }

        public Criteria andProviderRefnoNotIn(List<String> values) {
            addCriterion("PROVIDER_REFNO not in", values, "providerRefno");
            return (Criteria) this;
        }

        public Criteria andProviderRefnoBetween(String value1, String value2) {
            addCriterion("PROVIDER_REFNO between", value1, value2, "providerRefno");
            return (Criteria) this;
        }

        public Criteria andProviderRefnoNotBetween(String value1, String value2) {
            addCriterion("PROVIDER_REFNO not between", value1, value2, "providerRefno");
            return (Criteria) this;
        }

        public Criteria andEnglishNameIsNull() {
            addCriterion("ENGLISH_NAME is null");
            return (Criteria) this;
        }

        public Criteria andEnglishNameIsNotNull() {
            addCriterion("ENGLISH_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andEnglishNameEqualTo(String value) {
            addCriterion("ENGLISH_NAME =", value, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameNotEqualTo(String value) {
            addCriterion("ENGLISH_NAME <>", value, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameGreaterThan(String value) {
            addCriterion("ENGLISH_NAME >", value, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameGreaterThanOrEqualTo(String value) {
            addCriterion("ENGLISH_NAME >=", value, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameLessThan(String value) {
            addCriterion("ENGLISH_NAME <", value, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameLessThanOrEqualTo(String value) {
            addCriterion("ENGLISH_NAME <=", value, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameLike(String value) {
            addCriterion("ENGLISH_NAME like", value, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameNotLike(String value) {
            addCriterion("ENGLISH_NAME not like", value, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameIn(List<String> values) {
            addCriterion("ENGLISH_NAME in", values, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameNotIn(List<String> values) {
            addCriterion("ENGLISH_NAME not in", values, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameBetween(String value1, String value2) {
            addCriterion("ENGLISH_NAME between", value1, value2, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameNotBetween(String value1, String value2) {
            addCriterion("ENGLISH_NAME not between", value1, value2, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishAddrIsNull() {
            addCriterion("ENGLISH_ADDR is null");
            return (Criteria) this;
        }

        public Criteria andEnglishAddrIsNotNull() {
            addCriterion("ENGLISH_ADDR is not null");
            return (Criteria) this;
        }

        public Criteria andEnglishAddrEqualTo(String value) {
            addCriterion("ENGLISH_ADDR =", value, "englishAddr");
            return (Criteria) this;
        }

        public Criteria andEnglishAddrNotEqualTo(String value) {
            addCriterion("ENGLISH_ADDR <>", value, "englishAddr");
            return (Criteria) this;
        }

        public Criteria andEnglishAddrGreaterThan(String value) {
            addCriterion("ENGLISH_ADDR >", value, "englishAddr");
            return (Criteria) this;
        }

        public Criteria andEnglishAddrGreaterThanOrEqualTo(String value) {
            addCriterion("ENGLISH_ADDR >=", value, "englishAddr");
            return (Criteria) this;
        }

        public Criteria andEnglishAddrLessThan(String value) {
            addCriterion("ENGLISH_ADDR <", value, "englishAddr");
            return (Criteria) this;
        }

        public Criteria andEnglishAddrLessThanOrEqualTo(String value) {
            addCriterion("ENGLISH_ADDR <=", value, "englishAddr");
            return (Criteria) this;
        }

        public Criteria andEnglishAddrLike(String value) {
            addCriterion("ENGLISH_ADDR like", value, "englishAddr");
            return (Criteria) this;
        }

        public Criteria andEnglishAddrNotLike(String value) {
            addCriterion("ENGLISH_ADDR not like", value, "englishAddr");
            return (Criteria) this;
        }

        public Criteria andEnglishAddrIn(List<String> values) {
            addCriterion("ENGLISH_ADDR in", values, "englishAddr");
            return (Criteria) this;
        }

        public Criteria andEnglishAddrNotIn(List<String> values) {
            addCriterion("ENGLISH_ADDR not in", values, "englishAddr");
            return (Criteria) this;
        }

        public Criteria andEnglishAddrBetween(String value1, String value2) {
            addCriterion("ENGLISH_ADDR between", value1, value2, "englishAddr");
            return (Criteria) this;
        }

        public Criteria andEnglishAddrNotBetween(String value1, String value2) {
            addCriterion("ENGLISH_ADDR not between", value1, value2, "englishAddr");
            return (Criteria) this;
        }

        public Criteria andDiscrtIsNull() {
            addCriterion("DISCRT is null");
            return (Criteria) this;
        }

        public Criteria andDiscrtIsNotNull() {
            addCriterion("DISCRT is not null");
            return (Criteria) this;
        }

        public Criteria andDiscrtEqualTo(BigDecimal value) {
            addCriterion("DISCRT =", value, "discrt");
            return (Criteria) this;
        }

        public Criteria andDiscrtNotEqualTo(BigDecimal value) {
            addCriterion("DISCRT <>", value, "discrt");
            return (Criteria) this;
        }

        public Criteria andDiscrtGreaterThan(BigDecimal value) {
            addCriterion("DISCRT >", value, "discrt");
            return (Criteria) this;
        }

        public Criteria andDiscrtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("DISCRT >=", value, "discrt");
            return (Criteria) this;
        }

        public Criteria andDiscrtLessThan(BigDecimal value) {
            addCriterion("DISCRT <", value, "discrt");
            return (Criteria) this;
        }

        public Criteria andDiscrtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("DISCRT <=", value, "discrt");
            return (Criteria) this;
        }

        public Criteria andDiscrtIn(List<BigDecimal> values) {
            addCriterion("DISCRT in", values, "discrt");
            return (Criteria) this;
        }

        public Criteria andDiscrtNotIn(List<BigDecimal> values) {
            addCriterion("DISCRT not in", values, "discrt");
            return (Criteria) this;
        }

        public Criteria andDiscrtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DISCRT between", value1, value2, "discrt");
            return (Criteria) this;
        }

        public Criteria andDiscrtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DISCRT not between", value1, value2, "discrt");
            return (Criteria) this;
        }

        public Criteria andPanelStartdtIsNull() {
            addCriterion("PANEL_STARTDT is null");
            return (Criteria) this;
        }

        public Criteria andPanelStartdtIsNotNull() {
            addCriterion("PANEL_STARTDT is not null");
            return (Criteria) this;
        }

        public Criteria andPanelStartdtEqualTo(Date value) {
            addCriterion("PANEL_STARTDT =", value, "panelStartdt");
            return (Criteria) this;
        }

        public Criteria andPanelStartdtNotEqualTo(Date value) {
            addCriterion("PANEL_STARTDT <>", value, "panelStartdt");
            return (Criteria) this;
        }

        public Criteria andPanelStartdtGreaterThan(Date value) {
            addCriterion("PANEL_STARTDT >", value, "panelStartdt");
            return (Criteria) this;
        }

        public Criteria andPanelStartdtGreaterThanOrEqualTo(Date value) {
            addCriterion("PANEL_STARTDT >=", value, "panelStartdt");
            return (Criteria) this;
        }

        public Criteria andPanelStartdtLessThan(Date value) {
            addCriterion("PANEL_STARTDT <", value, "panelStartdt");
            return (Criteria) this;
        }

        public Criteria andPanelStartdtLessThanOrEqualTo(Date value) {
            addCriterion("PANEL_STARTDT <=", value, "panelStartdt");
            return (Criteria) this;
        }

        public Criteria andPanelStartdtIn(List<Date> values) {
            addCriterion("PANEL_STARTDT in", values, "panelStartdt");
            return (Criteria) this;
        }

        public Criteria andPanelStartdtNotIn(List<Date> values) {
            addCriterion("PANEL_STARTDT not in", values, "panelStartdt");
            return (Criteria) this;
        }

        public Criteria andPanelStartdtBetween(Date value1, Date value2) {
            addCriterion("PANEL_STARTDT between", value1, value2, "panelStartdt");
            return (Criteria) this;
        }

        public Criteria andPanelStartdtNotBetween(Date value1, Date value2) {
            addCriterion("PANEL_STARTDT not between", value1, value2, "panelStartdt");
            return (Criteria) this;
        }

        public Criteria andPanelEnddtIsNull() {
            addCriterion("PANEL_ENDDT is null");
            return (Criteria) this;
        }

        public Criteria andPanelEnddtIsNotNull() {
            addCriterion("PANEL_ENDDT is not null");
            return (Criteria) this;
        }

        public Criteria andPanelEnddtEqualTo(Date value) {
            addCriterion("PANEL_ENDDT =", value, "panelEnddt");
            return (Criteria) this;
        }

        public Criteria andPanelEnddtNotEqualTo(Date value) {
            addCriterion("PANEL_ENDDT <>", value, "panelEnddt");
            return (Criteria) this;
        }

        public Criteria andPanelEnddtGreaterThan(Date value) {
            addCriterion("PANEL_ENDDT >", value, "panelEnddt");
            return (Criteria) this;
        }

        public Criteria andPanelEnddtGreaterThanOrEqualTo(Date value) {
            addCriterion("PANEL_ENDDT >=", value, "panelEnddt");
            return (Criteria) this;
        }

        public Criteria andPanelEnddtLessThan(Date value) {
            addCriterion("PANEL_ENDDT <", value, "panelEnddt");
            return (Criteria) this;
        }

        public Criteria andPanelEnddtLessThanOrEqualTo(Date value) {
            addCriterion("PANEL_ENDDT <=", value, "panelEnddt");
            return (Criteria) this;
        }

        public Criteria andPanelEnddtIn(List<Date> values) {
            addCriterion("PANEL_ENDDT in", values, "panelEnddt");
            return (Criteria) this;
        }

        public Criteria andPanelEnddtNotIn(List<Date> values) {
            addCriterion("PANEL_ENDDT not in", values, "panelEnddt");
            return (Criteria) this;
        }

        public Criteria andPanelEnddtBetween(Date value1, Date value2) {
            addCriterion("PANEL_ENDDT between", value1, value2, "panelEnddt");
            return (Criteria) this;
        }

        public Criteria andPanelEnddtNotBetween(Date value1, Date value2) {
            addCriterion("PANEL_ENDDT not between", value1, value2, "panelEnddt");
            return (Criteria) this;
        }

        public Criteria andDiyNoteIsNull() {
            addCriterion("DIY_NOTE is null");
            return (Criteria) this;
        }

        public Criteria andDiyNoteIsNotNull() {
            addCriterion("DIY_NOTE is not null");
            return (Criteria) this;
        }

        public Criteria andDiyNoteEqualTo(String value) {
            addCriterion("DIY_NOTE =", value, "diyNote");
            return (Criteria) this;
        }

        public Criteria andDiyNoteNotEqualTo(String value) {
            addCriterion("DIY_NOTE <>", value, "diyNote");
            return (Criteria) this;
        }

        public Criteria andDiyNoteGreaterThan(String value) {
            addCriterion("DIY_NOTE >", value, "diyNote");
            return (Criteria) this;
        }

        public Criteria andDiyNoteGreaterThanOrEqualTo(String value) {
            addCriterion("DIY_NOTE >=", value, "diyNote");
            return (Criteria) this;
        }

        public Criteria andDiyNoteLessThan(String value) {
            addCriterion("DIY_NOTE <", value, "diyNote");
            return (Criteria) this;
        }

        public Criteria andDiyNoteLessThanOrEqualTo(String value) {
            addCriterion("DIY_NOTE <=", value, "diyNote");
            return (Criteria) this;
        }

        public Criteria andDiyNoteLike(String value) {
            addCriterion("DIY_NOTE like", value, "diyNote");
            return (Criteria) this;
        }

        public Criteria andDiyNoteNotLike(String value) {
            addCriterion("DIY_NOTE not like", value, "diyNote");
            return (Criteria) this;
        }

        public Criteria andDiyNoteIn(List<String> values) {
            addCriterion("DIY_NOTE in", values, "diyNote");
            return (Criteria) this;
        }

        public Criteria andDiyNoteNotIn(List<String> values) {
            addCriterion("DIY_NOTE not in", values, "diyNote");
            return (Criteria) this;
        }

        public Criteria andDiyNoteBetween(String value1, String value2) {
            addCriterion("DIY_NOTE between", value1, value2, "diyNote");
            return (Criteria) this;
        }

        public Criteria andDiyNoteNotBetween(String value1, String value2) {
            addCriterion("DIY_NOTE not between", value1, value2, "diyNote");
            return (Criteria) this;
        }

        public Criteria andSelfpaidCollectionIsNull() {
            addCriterion("SELFPAID_COLLECTION is null");
            return (Criteria) this;
        }

        public Criteria andSelfpaidCollectionIsNotNull() {
            addCriterion("SELFPAID_COLLECTION is not null");
            return (Criteria) this;
        }

        public Criteria andSelfpaidCollectionEqualTo(String value) {
            addCriterion("SELFPAID_COLLECTION =", value, "selfpaidCollection");
            return (Criteria) this;
        }

        public Criteria andSelfpaidCollectionNotEqualTo(String value) {
            addCriterion("SELFPAID_COLLECTION <>", value, "selfpaidCollection");
            return (Criteria) this;
        }

        public Criteria andSelfpaidCollectionGreaterThan(String value) {
            addCriterion("SELFPAID_COLLECTION >", value, "selfpaidCollection");
            return (Criteria) this;
        }

        public Criteria andSelfpaidCollectionGreaterThanOrEqualTo(String value) {
            addCriterion("SELFPAID_COLLECTION >=", value, "selfpaidCollection");
            return (Criteria) this;
        }

        public Criteria andSelfpaidCollectionLessThan(String value) {
            addCriterion("SELFPAID_COLLECTION <", value, "selfpaidCollection");
            return (Criteria) this;
        }

        public Criteria andSelfpaidCollectionLessThanOrEqualTo(String value) {
            addCriterion("SELFPAID_COLLECTION <=", value, "selfpaidCollection");
            return (Criteria) this;
        }

        public Criteria andSelfpaidCollectionLike(String value) {
            addCriterion("SELFPAID_COLLECTION like", value, "selfpaidCollection");
            return (Criteria) this;
        }

        public Criteria andSelfpaidCollectionNotLike(String value) {
            addCriterion("SELFPAID_COLLECTION not like", value, "selfpaidCollection");
            return (Criteria) this;
        }

        public Criteria andSelfpaidCollectionIn(List<String> values) {
            addCriterion("SELFPAID_COLLECTION in", values, "selfpaidCollection");
            return (Criteria) this;
        }

        public Criteria andSelfpaidCollectionNotIn(List<String> values) {
            addCriterion("SELFPAID_COLLECTION not in", values, "selfpaidCollection");
            return (Criteria) this;
        }

        public Criteria andSelfpaidCollectionBetween(String value1, String value2) {
            addCriterion("SELFPAID_COLLECTION between", value1, value2, "selfpaidCollection");
            return (Criteria) this;
        }

        public Criteria andSelfpaidCollectionNotBetween(String value1, String value2) {
            addCriterion("SELFPAID_COLLECTION not between", value1, value2, "selfpaidCollection");
            return (Criteria) this;
        }

        public Criteria andCurrcdIsNull() {
            addCriterion("CURRCD is null");
            return (Criteria) this;
        }

        public Criteria andCurrcdIsNotNull() {
            addCriterion("CURRCD is not null");
            return (Criteria) this;
        }

        public Criteria andCurrcdEqualTo(String value) {
            addCriterion("CURRCD =", value, "currcd");
            return (Criteria) this;
        }

        public Criteria andCurrcdNotEqualTo(String value) {
            addCriterion("CURRCD <>", value, "currcd");
            return (Criteria) this;
        }

        public Criteria andCurrcdGreaterThan(String value) {
            addCriterion("CURRCD >", value, "currcd");
            return (Criteria) this;
        }

        public Criteria andCurrcdGreaterThanOrEqualTo(String value) {
            addCriterion("CURRCD >=", value, "currcd");
            return (Criteria) this;
        }

        public Criteria andCurrcdLessThan(String value) {
            addCriterion("CURRCD <", value, "currcd");
            return (Criteria) this;
        }

        public Criteria andCurrcdLessThanOrEqualTo(String value) {
            addCriterion("CURRCD <=", value, "currcd");
            return (Criteria) this;
        }

        public Criteria andCurrcdLike(String value) {
            addCriterion("CURRCD like", value, "currcd");
            return (Criteria) this;
        }

        public Criteria andCurrcdNotLike(String value) {
            addCriterion("CURRCD not like", value, "currcd");
            return (Criteria) this;
        }

        public Criteria andCurrcdIn(List<String> values) {
            addCriterion("CURRCD in", values, "currcd");
            return (Criteria) this;
        }

        public Criteria andCurrcdNotIn(List<String> values) {
            addCriterion("CURRCD not in", values, "currcd");
            return (Criteria) this;
        }

        public Criteria andCurrcdBetween(String value1, String value2) {
            addCriterion("CURRCD between", value1, value2, "currcd");
            return (Criteria) this;
        }

        public Criteria andCurrcdNotBetween(String value1, String value2) {
            addCriterion("CURRCD not between", value1, value2, "currcd");
            return (Criteria) this;
        }

        public Criteria andPaymentModeIsNull() {
            addCriterion("PAYMENT_MODE is null");
            return (Criteria) this;
        }

        public Criteria andPaymentModeIsNotNull() {
            addCriterion("PAYMENT_MODE is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentModeEqualTo(String value) {
            addCriterion("PAYMENT_MODE =", value, "paymentMode");
            return (Criteria) this;
        }

        public Criteria andPaymentModeNotEqualTo(String value) {
            addCriterion("PAYMENT_MODE <>", value, "paymentMode");
            return (Criteria) this;
        }

        public Criteria andPaymentModeGreaterThan(String value) {
            addCriterion("PAYMENT_MODE >", value, "paymentMode");
            return (Criteria) this;
        }

        public Criteria andPaymentModeGreaterThanOrEqualTo(String value) {
            addCriterion("PAYMENT_MODE >=", value, "paymentMode");
            return (Criteria) this;
        }

        public Criteria andPaymentModeLessThan(String value) {
            addCriterion("PAYMENT_MODE <", value, "paymentMode");
            return (Criteria) this;
        }

        public Criteria andPaymentModeLessThanOrEqualTo(String value) {
            addCriterion("PAYMENT_MODE <=", value, "paymentMode");
            return (Criteria) this;
        }

        public Criteria andPaymentModeLike(String value) {
            addCriterion("PAYMENT_MODE like", value, "paymentMode");
            return (Criteria) this;
        }

        public Criteria andPaymentModeNotLike(String value) {
            addCriterion("PAYMENT_MODE not like", value, "paymentMode");
            return (Criteria) this;
        }

        public Criteria andPaymentModeIn(List<String> values) {
            addCriterion("PAYMENT_MODE in", values, "paymentMode");
            return (Criteria) this;
        }

        public Criteria andPaymentModeNotIn(List<String> values) {
            addCriterion("PAYMENT_MODE not in", values, "paymentMode");
            return (Criteria) this;
        }

        public Criteria andPaymentModeBetween(String value1, String value2) {
            addCriterion("PAYMENT_MODE between", value1, value2, "paymentMode");
            return (Criteria) this;
        }

        public Criteria andPaymentModeNotBetween(String value1, String value2) {
            addCriterion("PAYMENT_MODE not between", value1, value2, "paymentMode");
            return (Criteria) this;
        }

        public Criteria andPaymentFrequencyIsNull() {
            addCriterion("PAYMENT_FREQUENCY is null");
            return (Criteria) this;
        }

        public Criteria andPaymentFrequencyIsNotNull() {
            addCriterion("PAYMENT_FREQUENCY is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentFrequencyEqualTo(String value) {
            addCriterion("PAYMENT_FREQUENCY =", value, "paymentFrequency");
            return (Criteria) this;
        }

        public Criteria andPaymentFrequencyNotEqualTo(String value) {
            addCriterion("PAYMENT_FREQUENCY <>", value, "paymentFrequency");
            return (Criteria) this;
        }

        public Criteria andPaymentFrequencyGreaterThan(String value) {
            addCriterion("PAYMENT_FREQUENCY >", value, "paymentFrequency");
            return (Criteria) this;
        }

        public Criteria andPaymentFrequencyGreaterThanOrEqualTo(String value) {
            addCriterion("PAYMENT_FREQUENCY >=", value, "paymentFrequency");
            return (Criteria) this;
        }

        public Criteria andPaymentFrequencyLessThan(String value) {
            addCriterion("PAYMENT_FREQUENCY <", value, "paymentFrequency");
            return (Criteria) this;
        }

        public Criteria andPaymentFrequencyLessThanOrEqualTo(String value) {
            addCriterion("PAYMENT_FREQUENCY <=", value, "paymentFrequency");
            return (Criteria) this;
        }

        public Criteria andPaymentFrequencyLike(String value) {
            addCriterion("PAYMENT_FREQUENCY like", value, "paymentFrequency");
            return (Criteria) this;
        }

        public Criteria andPaymentFrequencyNotLike(String value) {
            addCriterion("PAYMENT_FREQUENCY not like", value, "paymentFrequency");
            return (Criteria) this;
        }

        public Criteria andPaymentFrequencyIn(List<String> values) {
            addCriterion("PAYMENT_FREQUENCY in", values, "paymentFrequency");
            return (Criteria) this;
        }

        public Criteria andPaymentFrequencyNotIn(List<String> values) {
            addCriterion("PAYMENT_FREQUENCY not in", values, "paymentFrequency");
            return (Criteria) this;
        }

        public Criteria andPaymentFrequencyBetween(String value1, String value2) {
            addCriterion("PAYMENT_FREQUENCY between", value1, value2, "paymentFrequency");
            return (Criteria) this;
        }

        public Criteria andPaymentFrequencyNotBetween(String value1, String value2) {
            addCriterion("PAYMENT_FREQUENCY not between", value1, value2, "paymentFrequency");
            return (Criteria) this;
        }

        public Criteria andPaymentDayIsNull() {
            addCriterion("PAYMENT_DAY is null");
            return (Criteria) this;
        }

        public Criteria andPaymentDayIsNotNull() {
            addCriterion("PAYMENT_DAY is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentDayEqualTo(Short value) {
            addCriterion("PAYMENT_DAY =", value, "paymentDay");
            return (Criteria) this;
        }

        public Criteria andPaymentDayNotEqualTo(Short value) {
            addCriterion("PAYMENT_DAY <>", value, "paymentDay");
            return (Criteria) this;
        }

        public Criteria andPaymentDayGreaterThan(Short value) {
            addCriterion("PAYMENT_DAY >", value, "paymentDay");
            return (Criteria) this;
        }

        public Criteria andPaymentDayGreaterThanOrEqualTo(Short value) {
            addCriterion("PAYMENT_DAY >=", value, "paymentDay");
            return (Criteria) this;
        }

        public Criteria andPaymentDayLessThan(Short value) {
            addCriterion("PAYMENT_DAY <", value, "paymentDay");
            return (Criteria) this;
        }

        public Criteria andPaymentDayLessThanOrEqualTo(Short value) {
            addCriterion("PAYMENT_DAY <=", value, "paymentDay");
            return (Criteria) this;
        }

        public Criteria andPaymentDayIn(List<Short> values) {
            addCriterion("PAYMENT_DAY in", values, "paymentDay");
            return (Criteria) this;
        }

        public Criteria andPaymentDayNotIn(List<Short> values) {
            addCriterion("PAYMENT_DAY not in", values, "paymentDay");
            return (Criteria) this;
        }

        public Criteria andPaymentDayBetween(Short value1, Short value2) {
            addCriterion("PAYMENT_DAY between", value1, value2, "paymentDay");
            return (Criteria) this;
        }

        public Criteria andPaymentDayNotBetween(Short value1, Short value2) {
            addCriterion("PAYMENT_DAY not between", value1, value2, "paymentDay");
            return (Criteria) this;
        }

        public Criteria andProviderCatIsNull() {
            addCriterion("PROVIDER_CAT is null");
            return (Criteria) this;
        }

        public Criteria andProviderCatIsNotNull() {
            addCriterion("PROVIDER_CAT is not null");
            return (Criteria) this;
        }

        public Criteria andProviderCatEqualTo(String value) {
            addCriterion("PROVIDER_CAT =", value, "providerCat");
            return (Criteria) this;
        }

        public Criteria andProviderCatNotEqualTo(String value) {
            addCriterion("PROVIDER_CAT <>", value, "providerCat");
            return (Criteria) this;
        }

        public Criteria andProviderCatGreaterThan(String value) {
            addCriterion("PROVIDER_CAT >", value, "providerCat");
            return (Criteria) this;
        }

        public Criteria andProviderCatGreaterThanOrEqualTo(String value) {
            addCriterion("PROVIDER_CAT >=", value, "providerCat");
            return (Criteria) this;
        }

        public Criteria andProviderCatLessThan(String value) {
            addCriterion("PROVIDER_CAT <", value, "providerCat");
            return (Criteria) this;
        }

        public Criteria andProviderCatLessThanOrEqualTo(String value) {
            addCriterion("PROVIDER_CAT <=", value, "providerCat");
            return (Criteria) this;
        }

        public Criteria andProviderCatLike(String value) {
            addCriterion("PROVIDER_CAT like", value, "providerCat");
            return (Criteria) this;
        }

        public Criteria andProviderCatNotLike(String value) {
            addCriterion("PROVIDER_CAT not like", value, "providerCat");
            return (Criteria) this;
        }

        public Criteria andProviderCatIn(List<String> values) {
            addCriterion("PROVIDER_CAT in", values, "providerCat");
            return (Criteria) this;
        }

        public Criteria andProviderCatNotIn(List<String> values) {
            addCriterion("PROVIDER_CAT not in", values, "providerCat");
            return (Criteria) this;
        }

        public Criteria andProviderCatBetween(String value1, String value2) {
            addCriterion("PROVIDER_CAT between", value1, value2, "providerCat");
            return (Criteria) this;
        }

        public Criteria andProviderCatNotBetween(String value1, String value2) {
            addCriterion("PROVIDER_CAT not between", value1, value2, "providerCat");
            return (Criteria) this;
        }

        public Criteria andCoverageProvidedIsNull() {
            addCriterion("COVERAGE_PROVIDED is null");
            return (Criteria) this;
        }

        public Criteria andCoverageProvidedIsNotNull() {
            addCriterion("COVERAGE_PROVIDED is not null");
            return (Criteria) this;
        }

        public Criteria andCoverageProvidedEqualTo(String value) {
            addCriterion("COVERAGE_PROVIDED =", value, "coverageProvided");
            return (Criteria) this;
        }

        public Criteria andCoverageProvidedNotEqualTo(String value) {
            addCriterion("COVERAGE_PROVIDED <>", value, "coverageProvided");
            return (Criteria) this;
        }

        public Criteria andCoverageProvidedGreaterThan(String value) {
            addCriterion("COVERAGE_PROVIDED >", value, "coverageProvided");
            return (Criteria) this;
        }

        public Criteria andCoverageProvidedGreaterThanOrEqualTo(String value) {
            addCriterion("COVERAGE_PROVIDED >=", value, "coverageProvided");
            return (Criteria) this;
        }

        public Criteria andCoverageProvidedLessThan(String value) {
            addCriterion("COVERAGE_PROVIDED <", value, "coverageProvided");
            return (Criteria) this;
        }

        public Criteria andCoverageProvidedLessThanOrEqualTo(String value) {
            addCriterion("COVERAGE_PROVIDED <=", value, "coverageProvided");
            return (Criteria) this;
        }

        public Criteria andCoverageProvidedLike(String value) {
            addCriterion("COVERAGE_PROVIDED like", value, "coverageProvided");
            return (Criteria) this;
        }

        public Criteria andCoverageProvidedNotLike(String value) {
            addCriterion("COVERAGE_PROVIDED not like", value, "coverageProvided");
            return (Criteria) this;
        }

        public Criteria andCoverageProvidedIn(List<String> values) {
            addCriterion("COVERAGE_PROVIDED in", values, "coverageProvided");
            return (Criteria) this;
        }

        public Criteria andCoverageProvidedNotIn(List<String> values) {
            addCriterion("COVERAGE_PROVIDED not in", values, "coverageProvided");
            return (Criteria) this;
        }

        public Criteria andCoverageProvidedBetween(String value1, String value2) {
            addCriterion("COVERAGE_PROVIDED between", value1, value2, "coverageProvided");
            return (Criteria) this;
        }

        public Criteria andCoverageProvidedNotBetween(String value1, String value2) {
            addCriterion("COVERAGE_PROVIDED not between", value1, value2, "coverageProvided");
            return (Criteria) this;
        }

        public Criteria andProviderSpecialityIsNull() {
            addCriterion("PROVIDER_SPECIALITY is null");
            return (Criteria) this;
        }

        public Criteria andProviderSpecialityIsNotNull() {
            addCriterion("PROVIDER_SPECIALITY is not null");
            return (Criteria) this;
        }

        public Criteria andProviderSpecialityEqualTo(String value) {
            addCriterion("PROVIDER_SPECIALITY =", value, "providerSpeciality");
            return (Criteria) this;
        }

        public Criteria andProviderSpecialityNotEqualTo(String value) {
            addCriterion("PROVIDER_SPECIALITY <>", value, "providerSpeciality");
            return (Criteria) this;
        }

        public Criteria andProviderSpecialityGreaterThan(String value) {
            addCriterion("PROVIDER_SPECIALITY >", value, "providerSpeciality");
            return (Criteria) this;
        }

        public Criteria andProviderSpecialityGreaterThanOrEqualTo(String value) {
            addCriterion("PROVIDER_SPECIALITY >=", value, "providerSpeciality");
            return (Criteria) this;
        }

        public Criteria andProviderSpecialityLessThan(String value) {
            addCriterion("PROVIDER_SPECIALITY <", value, "providerSpeciality");
            return (Criteria) this;
        }

        public Criteria andProviderSpecialityLessThanOrEqualTo(String value) {
            addCriterion("PROVIDER_SPECIALITY <=", value, "providerSpeciality");
            return (Criteria) this;
        }

        public Criteria andProviderSpecialityLike(String value) {
            addCriterion("PROVIDER_SPECIALITY like", value, "providerSpeciality");
            return (Criteria) this;
        }

        public Criteria andProviderSpecialityNotLike(String value) {
            addCriterion("PROVIDER_SPECIALITY not like", value, "providerSpeciality");
            return (Criteria) this;
        }

        public Criteria andProviderSpecialityIn(List<String> values) {
            addCriterion("PROVIDER_SPECIALITY in", values, "providerSpeciality");
            return (Criteria) this;
        }

        public Criteria andProviderSpecialityNotIn(List<String> values) {
            addCriterion("PROVIDER_SPECIALITY not in", values, "providerSpeciality");
            return (Criteria) this;
        }

        public Criteria andProviderSpecialityBetween(String value1, String value2) {
            addCriterion("PROVIDER_SPECIALITY between", value1, value2, "providerSpeciality");
            return (Criteria) this;
        }

        public Criteria andProviderSpecialityNotBetween(String value1, String value2) {
            addCriterion("PROVIDER_SPECIALITY not between", value1, value2, "providerSpeciality");
            return (Criteria) this;
        }

        public Criteria andProviderLevelIsNull() {
            addCriterion("PROVIDER_LEVEL is null");
            return (Criteria) this;
        }

        public Criteria andProviderLevelIsNotNull() {
            addCriterion("PROVIDER_LEVEL is not null");
            return (Criteria) this;
        }

        public Criteria andProviderLevelEqualTo(String value) {
            addCriterion("PROVIDER_LEVEL =", value, "providerLevel");
            return (Criteria) this;
        }

        public Criteria andProviderLevelNotEqualTo(String value) {
            addCriterion("PROVIDER_LEVEL <>", value, "providerLevel");
            return (Criteria) this;
        }

        public Criteria andProviderLevelGreaterThan(String value) {
            addCriterion("PROVIDER_LEVEL >", value, "providerLevel");
            return (Criteria) this;
        }

        public Criteria andProviderLevelGreaterThanOrEqualTo(String value) {
            addCriterion("PROVIDER_LEVEL >=", value, "providerLevel");
            return (Criteria) this;
        }

        public Criteria andProviderLevelLessThan(String value) {
            addCriterion("PROVIDER_LEVEL <", value, "providerLevel");
            return (Criteria) this;
        }

        public Criteria andProviderLevelLessThanOrEqualTo(String value) {
            addCriterion("PROVIDER_LEVEL <=", value, "providerLevel");
            return (Criteria) this;
        }

        public Criteria andProviderLevelLike(String value) {
            addCriterion("PROVIDER_LEVEL like", value, "providerLevel");
            return (Criteria) this;
        }

        public Criteria andProviderLevelNotLike(String value) {
            addCriterion("PROVIDER_LEVEL not like", value, "providerLevel");
            return (Criteria) this;
        }

        public Criteria andProviderLevelIn(List<String> values) {
            addCriterion("PROVIDER_LEVEL in", values, "providerLevel");
            return (Criteria) this;
        }

        public Criteria andProviderLevelNotIn(List<String> values) {
            addCriterion("PROVIDER_LEVEL not in", values, "providerLevel");
            return (Criteria) this;
        }

        public Criteria andProviderLevelBetween(String value1, String value2) {
            addCriterion("PROVIDER_LEVEL between", value1, value2, "providerLevel");
            return (Criteria) this;
        }

        public Criteria andProviderLevelNotBetween(String value1, String value2) {
            addCriterion("PROVIDER_LEVEL not between", value1, value2, "providerLevel");
            return (Criteria) this;
        }

        public Criteria andNoOfBedIsNull() {
            addCriterion("NO_OF_BED is null");
            return (Criteria) this;
        }

        public Criteria andNoOfBedIsNotNull() {
            addCriterion("NO_OF_BED is not null");
            return (Criteria) this;
        }

        public Criteria andNoOfBedEqualTo(Integer value) {
            addCriterion("NO_OF_BED =", value, "noOfBed");
            return (Criteria) this;
        }

        public Criteria andNoOfBedNotEqualTo(Integer value) {
            addCriterion("NO_OF_BED <>", value, "noOfBed");
            return (Criteria) this;
        }

        public Criteria andNoOfBedGreaterThan(Integer value) {
            addCriterion("NO_OF_BED >", value, "noOfBed");
            return (Criteria) this;
        }

        public Criteria andNoOfBedGreaterThanOrEqualTo(Integer value) {
            addCriterion("NO_OF_BED >=", value, "noOfBed");
            return (Criteria) this;
        }

        public Criteria andNoOfBedLessThan(Integer value) {
            addCriterion("NO_OF_BED <", value, "noOfBed");
            return (Criteria) this;
        }

        public Criteria andNoOfBedLessThanOrEqualTo(Integer value) {
            addCriterion("NO_OF_BED <=", value, "noOfBed");
            return (Criteria) this;
        }

        public Criteria andNoOfBedIn(List<Integer> values) {
            addCriterion("NO_OF_BED in", values, "noOfBed");
            return (Criteria) this;
        }

        public Criteria andNoOfBedNotIn(List<Integer> values) {
            addCriterion("NO_OF_BED not in", values, "noOfBed");
            return (Criteria) this;
        }

        public Criteria andNoOfBedBetween(Integer value1, Integer value2) {
            addCriterion("NO_OF_BED between", value1, value2, "noOfBed");
            return (Criteria) this;
        }

        public Criteria andNoOfBedNotBetween(Integer value1, Integer value2) {
            addCriterion("NO_OF_BED not between", value1, value2, "noOfBed");
            return (Criteria) this;
        }

        public Criteria andMapurlIsNull() {
            addCriterion("MAPURL is null");
            return (Criteria) this;
        }

        public Criteria andMapurlIsNotNull() {
            addCriterion("MAPURL is not null");
            return (Criteria) this;
        }

        public Criteria andMapurlEqualTo(String value) {
            addCriterion("MAPURL =", value, "mapurl");
            return (Criteria) this;
        }

        public Criteria andMapurlNotEqualTo(String value) {
            addCriterion("MAPURL <>", value, "mapurl");
            return (Criteria) this;
        }

        public Criteria andMapurlGreaterThan(String value) {
            addCriterion("MAPURL >", value, "mapurl");
            return (Criteria) this;
        }

        public Criteria andMapurlGreaterThanOrEqualTo(String value) {
            addCriterion("MAPURL >=", value, "mapurl");
            return (Criteria) this;
        }

        public Criteria andMapurlLessThan(String value) {
            addCriterion("MAPURL <", value, "mapurl");
            return (Criteria) this;
        }

        public Criteria andMapurlLessThanOrEqualTo(String value) {
            addCriterion("MAPURL <=", value, "mapurl");
            return (Criteria) this;
        }

        public Criteria andMapurlLike(String value) {
            addCriterion("MAPURL like", value, "mapurl");
            return (Criteria) this;
        }

        public Criteria andMapurlNotLike(String value) {
            addCriterion("MAPURL not like", value, "mapurl");
            return (Criteria) this;
        }

        public Criteria andMapurlIn(List<String> values) {
            addCriterion("MAPURL in", values, "mapurl");
            return (Criteria) this;
        }

        public Criteria andMapurlNotIn(List<String> values) {
            addCriterion("MAPURL not in", values, "mapurl");
            return (Criteria) this;
        }

        public Criteria andMapurlBetween(String value1, String value2) {
            addCriterion("MAPURL between", value1, value2, "mapurl");
            return (Criteria) this;
        }

        public Criteria andMapurlNotBetween(String value1, String value2) {
            addCriterion("MAPURL not between", value1, value2, "mapurl");
            return (Criteria) this;
        }

        public Criteria andFeeCatgIsNull() {
            addCriterion("FEE_CATG is null");
            return (Criteria) this;
        }

        public Criteria andFeeCatgIsNotNull() {
            addCriterion("FEE_CATG is not null");
            return (Criteria) this;
        }

        public Criteria andFeeCatgEqualTo(String value) {
            addCriterion("FEE_CATG =", value, "feeCatg");
            return (Criteria) this;
        }

        public Criteria andFeeCatgNotEqualTo(String value) {
            addCriterion("FEE_CATG <>", value, "feeCatg");
            return (Criteria) this;
        }

        public Criteria andFeeCatgGreaterThan(String value) {
            addCriterion("FEE_CATG >", value, "feeCatg");
            return (Criteria) this;
        }

        public Criteria andFeeCatgGreaterThanOrEqualTo(String value) {
            addCriterion("FEE_CATG >=", value, "feeCatg");
            return (Criteria) this;
        }

        public Criteria andFeeCatgLessThan(String value) {
            addCriterion("FEE_CATG <", value, "feeCatg");
            return (Criteria) this;
        }

        public Criteria andFeeCatgLessThanOrEqualTo(String value) {
            addCriterion("FEE_CATG <=", value, "feeCatg");
            return (Criteria) this;
        }

        public Criteria andFeeCatgLike(String value) {
            addCriterion("FEE_CATG like", value, "feeCatg");
            return (Criteria) this;
        }

        public Criteria andFeeCatgNotLike(String value) {
            addCriterion("FEE_CATG not like", value, "feeCatg");
            return (Criteria) this;
        }

        public Criteria andFeeCatgIn(List<String> values) {
            addCriterion("FEE_CATG in", values, "feeCatg");
            return (Criteria) this;
        }

        public Criteria andFeeCatgNotIn(List<String> values) {
            addCriterion("FEE_CATG not in", values, "feeCatg");
            return (Criteria) this;
        }

        public Criteria andFeeCatgBetween(String value1, String value2) {
            addCriterion("FEE_CATG between", value1, value2, "feeCatg");
            return (Criteria) this;
        }

        public Criteria andFeeCatgNotBetween(String value1, String value2) {
            addCriterion("FEE_CATG not between", value1, value2, "feeCatg");
            return (Criteria) this;
        }

        public Criteria andSocialMedicalPanelIsNull() {
            addCriterion("SOCIAL_MEDICAL_PANEL is null");
            return (Criteria) this;
        }

        public Criteria andSocialMedicalPanelIsNotNull() {
            addCriterion("SOCIAL_MEDICAL_PANEL is not null");
            return (Criteria) this;
        }

        public Criteria andSocialMedicalPanelEqualTo(String value) {
            addCriterion("SOCIAL_MEDICAL_PANEL =", value, "socialMedicalPanel");
            return (Criteria) this;
        }

        public Criteria andSocialMedicalPanelNotEqualTo(String value) {
            addCriterion("SOCIAL_MEDICAL_PANEL <>", value, "socialMedicalPanel");
            return (Criteria) this;
        }

        public Criteria andSocialMedicalPanelGreaterThan(String value) {
            addCriterion("SOCIAL_MEDICAL_PANEL >", value, "socialMedicalPanel");
            return (Criteria) this;
        }

        public Criteria andSocialMedicalPanelGreaterThanOrEqualTo(String value) {
            addCriterion("SOCIAL_MEDICAL_PANEL >=", value, "socialMedicalPanel");
            return (Criteria) this;
        }

        public Criteria andSocialMedicalPanelLessThan(String value) {
            addCriterion("SOCIAL_MEDICAL_PANEL <", value, "socialMedicalPanel");
            return (Criteria) this;
        }

        public Criteria andSocialMedicalPanelLessThanOrEqualTo(String value) {
            addCriterion("SOCIAL_MEDICAL_PANEL <=", value, "socialMedicalPanel");
            return (Criteria) this;
        }

        public Criteria andSocialMedicalPanelLike(String value) {
            addCriterion("SOCIAL_MEDICAL_PANEL like", value, "socialMedicalPanel");
            return (Criteria) this;
        }

        public Criteria andSocialMedicalPanelNotLike(String value) {
            addCriterion("SOCIAL_MEDICAL_PANEL not like", value, "socialMedicalPanel");
            return (Criteria) this;
        }

        public Criteria andSocialMedicalPanelIn(List<String> values) {
            addCriterion("SOCIAL_MEDICAL_PANEL in", values, "socialMedicalPanel");
            return (Criteria) this;
        }

        public Criteria andSocialMedicalPanelNotIn(List<String> values) {
            addCriterion("SOCIAL_MEDICAL_PANEL not in", values, "socialMedicalPanel");
            return (Criteria) this;
        }

        public Criteria andSocialMedicalPanelBetween(String value1, String value2) {
            addCriterion("SOCIAL_MEDICAL_PANEL between", value1, value2, "socialMedicalPanel");
            return (Criteria) this;
        }

        public Criteria andSocialMedicalPanelNotBetween(String value1, String value2) {
            addCriterion("SOCIAL_MEDICAL_PANEL not between", value1, value2, "socialMedicalPanel");
            return (Criteria) this;
        }

        public Criteria andIssueInvoiceUponDischargeIsNull() {
            addCriterion("ISSUE_INVOICE_UPON_DISCHARGE is null");
            return (Criteria) this;
        }

        public Criteria andIssueInvoiceUponDischargeIsNotNull() {
            addCriterion("ISSUE_INVOICE_UPON_DISCHARGE is not null");
            return (Criteria) this;
        }

        public Criteria andIssueInvoiceUponDischargeEqualTo(String value) {
            addCriterion("ISSUE_INVOICE_UPON_DISCHARGE =", value, "issueInvoiceUponDischarge");
            return (Criteria) this;
        }

        public Criteria andIssueInvoiceUponDischargeNotEqualTo(String value) {
            addCriterion("ISSUE_INVOICE_UPON_DISCHARGE <>", value, "issueInvoiceUponDischarge");
            return (Criteria) this;
        }

        public Criteria andIssueInvoiceUponDischargeGreaterThan(String value) {
            addCriterion("ISSUE_INVOICE_UPON_DISCHARGE >", value, "issueInvoiceUponDischarge");
            return (Criteria) this;
        }

        public Criteria andIssueInvoiceUponDischargeGreaterThanOrEqualTo(String value) {
            addCriterion("ISSUE_INVOICE_UPON_DISCHARGE >=", value, "issueInvoiceUponDischarge");
            return (Criteria) this;
        }

        public Criteria andIssueInvoiceUponDischargeLessThan(String value) {
            addCriterion("ISSUE_INVOICE_UPON_DISCHARGE <", value, "issueInvoiceUponDischarge");
            return (Criteria) this;
        }

        public Criteria andIssueInvoiceUponDischargeLessThanOrEqualTo(String value) {
            addCriterion("ISSUE_INVOICE_UPON_DISCHARGE <=", value, "issueInvoiceUponDischarge");
            return (Criteria) this;
        }

        public Criteria andIssueInvoiceUponDischargeLike(String value) {
            addCriterion("ISSUE_INVOICE_UPON_DISCHARGE like", value, "issueInvoiceUponDischarge");
            return (Criteria) this;
        }

        public Criteria andIssueInvoiceUponDischargeNotLike(String value) {
            addCriterion("ISSUE_INVOICE_UPON_DISCHARGE not like", value, "issueInvoiceUponDischarge");
            return (Criteria) this;
        }

        public Criteria andIssueInvoiceUponDischargeIn(List<String> values) {
            addCriterion("ISSUE_INVOICE_UPON_DISCHARGE in", values, "issueInvoiceUponDischarge");
            return (Criteria) this;
        }

        public Criteria andIssueInvoiceUponDischargeNotIn(List<String> values) {
            addCriterion("ISSUE_INVOICE_UPON_DISCHARGE not in", values, "issueInvoiceUponDischarge");
            return (Criteria) this;
        }

        public Criteria andIssueInvoiceUponDischargeBetween(String value1, String value2) {
            addCriterion("ISSUE_INVOICE_UPON_DISCHARGE between", value1, value2, "issueInvoiceUponDischarge");
            return (Criteria) this;
        }

        public Criteria andIssueInvoiceUponDischargeNotBetween(String value1, String value2) {
            addCriterion("ISSUE_INVOICE_UPON_DISCHARGE not between", value1, value2, "issueInvoiceUponDischarge");
            return (Criteria) this;
        }

        public Criteria andPanelContractingIsNull() {
            addCriterion("PANEL_CONTRACTING is null");
            return (Criteria) this;
        }

        public Criteria andPanelContractingIsNotNull() {
            addCriterion("PANEL_CONTRACTING is not null");
            return (Criteria) this;
        }

        public Criteria andPanelContractingEqualTo(String value) {
            addCriterion("PANEL_CONTRACTING =", value, "panelContracting");
            return (Criteria) this;
        }

        public Criteria andPanelContractingNotEqualTo(String value) {
            addCriterion("PANEL_CONTRACTING <>", value, "panelContracting");
            return (Criteria) this;
        }

        public Criteria andPanelContractingGreaterThan(String value) {
            addCriterion("PANEL_CONTRACTING >", value, "panelContracting");
            return (Criteria) this;
        }

        public Criteria andPanelContractingGreaterThanOrEqualTo(String value) {
            addCriterion("PANEL_CONTRACTING >=", value, "panelContracting");
            return (Criteria) this;
        }

        public Criteria andPanelContractingLessThan(String value) {
            addCriterion("PANEL_CONTRACTING <", value, "panelContracting");
            return (Criteria) this;
        }

        public Criteria andPanelContractingLessThanOrEqualTo(String value) {
            addCriterion("PANEL_CONTRACTING <=", value, "panelContracting");
            return (Criteria) this;
        }

        public Criteria andPanelContractingLike(String value) {
            addCriterion("PANEL_CONTRACTING like", value, "panelContracting");
            return (Criteria) this;
        }

        public Criteria andPanelContractingNotLike(String value) {
            addCriterion("PANEL_CONTRACTING not like", value, "panelContracting");
            return (Criteria) this;
        }

        public Criteria andPanelContractingIn(List<String> values) {
            addCriterion("PANEL_CONTRACTING in", values, "panelContracting");
            return (Criteria) this;
        }

        public Criteria andPanelContractingNotIn(List<String> values) {
            addCriterion("PANEL_CONTRACTING not in", values, "panelContracting");
            return (Criteria) this;
        }

        public Criteria andPanelContractingBetween(String value1, String value2) {
            addCriterion("PANEL_CONTRACTING between", value1, value2, "panelContracting");
            return (Criteria) this;
        }

        public Criteria andPanelContractingNotBetween(String value1, String value2) {
            addCriterion("PANEL_CONTRACTING not between", value1, value2, "panelContracting");
            return (Criteria) this;
        }

        public Criteria andBillConsumableIsNull() {
            addCriterion("BILL_CONSUMABLE is null");
            return (Criteria) this;
        }

        public Criteria andBillConsumableIsNotNull() {
            addCriterion("BILL_CONSUMABLE is not null");
            return (Criteria) this;
        }

        public Criteria andBillConsumableEqualTo(String value) {
            addCriterion("BILL_CONSUMABLE =", value, "billConsumable");
            return (Criteria) this;
        }

        public Criteria andBillConsumableNotEqualTo(String value) {
            addCriterion("BILL_CONSUMABLE <>", value, "billConsumable");
            return (Criteria) this;
        }

        public Criteria andBillConsumableGreaterThan(String value) {
            addCriterion("BILL_CONSUMABLE >", value, "billConsumable");
            return (Criteria) this;
        }

        public Criteria andBillConsumableGreaterThanOrEqualTo(String value) {
            addCriterion("BILL_CONSUMABLE >=", value, "billConsumable");
            return (Criteria) this;
        }

        public Criteria andBillConsumableLessThan(String value) {
            addCriterion("BILL_CONSUMABLE <", value, "billConsumable");
            return (Criteria) this;
        }

        public Criteria andBillConsumableLessThanOrEqualTo(String value) {
            addCriterion("BILL_CONSUMABLE <=", value, "billConsumable");
            return (Criteria) this;
        }

        public Criteria andBillConsumableLike(String value) {
            addCriterion("BILL_CONSUMABLE like", value, "billConsumable");
            return (Criteria) this;
        }

        public Criteria andBillConsumableNotLike(String value) {
            addCriterion("BILL_CONSUMABLE not like", value, "billConsumable");
            return (Criteria) this;
        }

        public Criteria andBillConsumableIn(List<String> values) {
            addCriterion("BILL_CONSUMABLE in", values, "billConsumable");
            return (Criteria) this;
        }

        public Criteria andBillConsumableNotIn(List<String> values) {
            addCriterion("BILL_CONSUMABLE not in", values, "billConsumable");
            return (Criteria) this;
        }

        public Criteria andBillConsumableBetween(String value1, String value2) {
            addCriterion("BILL_CONSUMABLE between", value1, value2, "billConsumable");
            return (Criteria) this;
        }

        public Criteria andBillConsumableNotBetween(String value1, String value2) {
            addCriterion("BILL_CONSUMABLE not between", value1, value2, "billConsumable");
            return (Criteria) this;
        }

        public Criteria andGstnoIsNull() {
            addCriterion("GSTNO is null");
            return (Criteria) this;
        }

        public Criteria andGstnoIsNotNull() {
            addCriterion("GSTNO is not null");
            return (Criteria) this;
        }

        public Criteria andGstnoEqualTo(String value) {
            addCriterion("GSTNO =", value, "gstno");
            return (Criteria) this;
        }

        public Criteria andGstnoNotEqualTo(String value) {
            addCriterion("GSTNO <>", value, "gstno");
            return (Criteria) this;
        }

        public Criteria andGstnoGreaterThan(String value) {
            addCriterion("GSTNO >", value, "gstno");
            return (Criteria) this;
        }

        public Criteria andGstnoGreaterThanOrEqualTo(String value) {
            addCriterion("GSTNO >=", value, "gstno");
            return (Criteria) this;
        }

        public Criteria andGstnoLessThan(String value) {
            addCriterion("GSTNO <", value, "gstno");
            return (Criteria) this;
        }

        public Criteria andGstnoLessThanOrEqualTo(String value) {
            addCriterion("GSTNO <=", value, "gstno");
            return (Criteria) this;
        }

        public Criteria andGstnoLike(String value) {
            addCriterion("GSTNO like", value, "gstno");
            return (Criteria) this;
        }

        public Criteria andGstnoNotLike(String value) {
            addCriterion("GSTNO not like", value, "gstno");
            return (Criteria) this;
        }

        public Criteria andGstnoIn(List<String> values) {
            addCriterion("GSTNO in", values, "gstno");
            return (Criteria) this;
        }

        public Criteria andGstnoNotIn(List<String> values) {
            addCriterion("GSTNO not in", values, "gstno");
            return (Criteria) this;
        }

        public Criteria andGstnoBetween(String value1, String value2) {
            addCriterion("GSTNO between", value1, value2, "gstno");
            return (Criteria) this;
        }

        public Criteria andGstnoNotBetween(String value1, String value2) {
            addCriterion("GSTNO not between", value1, value2, "gstno");
            return (Criteria) this;
        }

        public Criteria andBankBranchCodeIsNull() {
            addCriterion("BANK_BRANCH_CODE is null");
            return (Criteria) this;
        }

        public Criteria andBankBranchCodeIsNotNull() {
            addCriterion("BANK_BRANCH_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andBankBranchCodeEqualTo(String value) {
            addCriterion("BANK_BRANCH_CODE =", value, "bankBranchCode");
            return (Criteria) this;
        }

        public Criteria andBankBranchCodeNotEqualTo(String value) {
            addCriterion("BANK_BRANCH_CODE <>", value, "bankBranchCode");
            return (Criteria) this;
        }

        public Criteria andBankBranchCodeGreaterThan(String value) {
            addCriterion("BANK_BRANCH_CODE >", value, "bankBranchCode");
            return (Criteria) this;
        }

        public Criteria andBankBranchCodeGreaterThanOrEqualTo(String value) {
            addCriterion("BANK_BRANCH_CODE >=", value, "bankBranchCode");
            return (Criteria) this;
        }

        public Criteria andBankBranchCodeLessThan(String value) {
            addCriterion("BANK_BRANCH_CODE <", value, "bankBranchCode");
            return (Criteria) this;
        }

        public Criteria andBankBranchCodeLessThanOrEqualTo(String value) {
            addCriterion("BANK_BRANCH_CODE <=", value, "bankBranchCode");
            return (Criteria) this;
        }

        public Criteria andBankBranchCodeLike(String value) {
            addCriterion("BANK_BRANCH_CODE like", value, "bankBranchCode");
            return (Criteria) this;
        }

        public Criteria andBankBranchCodeNotLike(String value) {
            addCriterion("BANK_BRANCH_CODE not like", value, "bankBranchCode");
            return (Criteria) this;
        }

        public Criteria andBankBranchCodeIn(List<String> values) {
            addCriterion("BANK_BRANCH_CODE in", values, "bankBranchCode");
            return (Criteria) this;
        }

        public Criteria andBankBranchCodeNotIn(List<String> values) {
            addCriterion("BANK_BRANCH_CODE not in", values, "bankBranchCode");
            return (Criteria) this;
        }

        public Criteria andBankBranchCodeBetween(String value1, String value2) {
            addCriterion("BANK_BRANCH_CODE between", value1, value2, "bankBranchCode");
            return (Criteria) this;
        }

        public Criteria andBankBranchCodeNotBetween(String value1, String value2) {
            addCriterion("BANK_BRANCH_CODE not between", value1, value2, "bankBranchCode");
            return (Criteria) this;
        }

        public Criteria andProviderTypeDispIsNull() {
            addCriterion("PROVIDER_TYPE_DISP is null");
            return (Criteria) this;
        }

        public Criteria andProviderTypeDispIsNotNull() {
            addCriterion("PROVIDER_TYPE_DISP is not null");
            return (Criteria) this;
        }

        public Criteria andProviderTypeDispEqualTo(String value) {
            addCriterion("PROVIDER_TYPE_DISP =", value, "providerTypeDisp");
            return (Criteria) this;
        }

        public Criteria andProviderTypeDispNotEqualTo(String value) {
            addCriterion("PROVIDER_TYPE_DISP <>", value, "providerTypeDisp");
            return (Criteria) this;
        }

        public Criteria andProviderTypeDispGreaterThan(String value) {
            addCriterion("PROVIDER_TYPE_DISP >", value, "providerTypeDisp");
            return (Criteria) this;
        }

        public Criteria andProviderTypeDispGreaterThanOrEqualTo(String value) {
            addCriterion("PROVIDER_TYPE_DISP >=", value, "providerTypeDisp");
            return (Criteria) this;
        }

        public Criteria andProviderTypeDispLessThan(String value) {
            addCriterion("PROVIDER_TYPE_DISP <", value, "providerTypeDisp");
            return (Criteria) this;
        }

        public Criteria andProviderTypeDispLessThanOrEqualTo(String value) {
            addCriterion("PROVIDER_TYPE_DISP <=", value, "providerTypeDisp");
            return (Criteria) this;
        }

        public Criteria andProviderTypeDispLike(String value) {
            addCriterion("PROVIDER_TYPE_DISP like", value, "providerTypeDisp");
            return (Criteria) this;
        }

        public Criteria andProviderTypeDispNotLike(String value) {
            addCriterion("PROVIDER_TYPE_DISP not like", value, "providerTypeDisp");
            return (Criteria) this;
        }

        public Criteria andProviderTypeDispIn(List<String> values) {
            addCriterion("PROVIDER_TYPE_DISP in", values, "providerTypeDisp");
            return (Criteria) this;
        }

        public Criteria andProviderTypeDispNotIn(List<String> values) {
            addCriterion("PROVIDER_TYPE_DISP not in", values, "providerTypeDisp");
            return (Criteria) this;
        }

        public Criteria andProviderTypeDispBetween(String value1, String value2) {
            addCriterion("PROVIDER_TYPE_DISP between", value1, value2, "providerTypeDisp");
            return (Criteria) this;
        }

        public Criteria andProviderTypeDispNotBetween(String value1, String value2) {
            addCriterion("PROVIDER_TYPE_DISP not between", value1, value2, "providerTypeDisp");
            return (Criteria) this;
        }

        public Criteria andWebsiteIsNull() {
            addCriterion("WEBSITE is null");
            return (Criteria) this;
        }

        public Criteria andWebsiteIsNotNull() {
            addCriterion("WEBSITE is not null");
            return (Criteria) this;
        }

        public Criteria andWebsiteEqualTo(String value) {
            addCriterion("WEBSITE =", value, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteNotEqualTo(String value) {
            addCriterion("WEBSITE <>", value, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteGreaterThan(String value) {
            addCriterion("WEBSITE >", value, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteGreaterThanOrEqualTo(String value) {
            addCriterion("WEBSITE >=", value, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteLessThan(String value) {
            addCriterion("WEBSITE <", value, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteLessThanOrEqualTo(String value) {
            addCriterion("WEBSITE <=", value, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteLike(String value) {
            addCriterion("WEBSITE like", value, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteNotLike(String value) {
            addCriterion("WEBSITE not like", value, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteIn(List<String> values) {
            addCriterion("WEBSITE in", values, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteNotIn(List<String> values) {
            addCriterion("WEBSITE not in", values, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteBetween(String value1, String value2) {
            addCriterion("WEBSITE between", value1, value2, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteNotBetween(String value1, String value2) {
            addCriterion("WEBSITE not between", value1, value2, "website");
            return (Criteria) this;
        }

        public Criteria andCrcdIsNull() {
            addCriterion("CRCD is null");
            return (Criteria) this;
        }

        public Criteria andCrcdIsNotNull() {
            addCriterion("CRCD is not null");
            return (Criteria) this;
        }

        public Criteria andCrcdEqualTo(String value) {
            addCriterion("CRCD =", value, "crcd");
            return (Criteria) this;
        }

        public Criteria andCrcdNotEqualTo(String value) {
            addCriterion("CRCD <>", value, "crcd");
            return (Criteria) this;
        }

        public Criteria andCrcdGreaterThan(String value) {
            addCriterion("CRCD >", value, "crcd");
            return (Criteria) this;
        }

        public Criteria andCrcdGreaterThanOrEqualTo(String value) {
            addCriterion("CRCD >=", value, "crcd");
            return (Criteria) this;
        }

        public Criteria andCrcdLessThan(String value) {
            addCriterion("CRCD <", value, "crcd");
            return (Criteria) this;
        }

        public Criteria andCrcdLessThanOrEqualTo(String value) {
            addCriterion("CRCD <=", value, "crcd");
            return (Criteria) this;
        }

        public Criteria andCrcdLike(String value) {
            addCriterion("CRCD like", value, "crcd");
            return (Criteria) this;
        }

        public Criteria andCrcdNotLike(String value) {
            addCriterion("CRCD not like", value, "crcd");
            return (Criteria) this;
        }

        public Criteria andCrcdIn(List<String> values) {
            addCriterion("CRCD in", values, "crcd");
            return (Criteria) this;
        }

        public Criteria andCrcdNotIn(List<String> values) {
            addCriterion("CRCD not in", values, "crcd");
            return (Criteria) this;
        }

        public Criteria andCrcdBetween(String value1, String value2) {
            addCriterion("CRCD between", value1, value2, "crcd");
            return (Criteria) this;
        }

        public Criteria andCrcdNotBetween(String value1, String value2) {
            addCriterion("CRCD not between", value1, value2, "crcd");
            return (Criteria) this;
        }

        public Criteria andSiteidIsNull() {
            addCriterion("SITEID is null");
            return (Criteria) this;
        }

        public Criteria andSiteidIsNotNull() {
            addCriterion("SITEID is not null");
            return (Criteria) this;
        }

        public Criteria andSiteidEqualTo(String value) {
            addCriterion("SITEID =", value, "siteid");
            return (Criteria) this;
        }

        public Criteria andSiteidNotEqualTo(String value) {
            addCriterion("SITEID <>", value, "siteid");
            return (Criteria) this;
        }

        public Criteria andSiteidGreaterThan(String value) {
            addCriterion("SITEID >", value, "siteid");
            return (Criteria) this;
        }

        public Criteria andSiteidGreaterThanOrEqualTo(String value) {
            addCriterion("SITEID >=", value, "siteid");
            return (Criteria) this;
        }

        public Criteria andSiteidLessThan(String value) {
            addCriterion("SITEID <", value, "siteid");
            return (Criteria) this;
        }

        public Criteria andSiteidLessThanOrEqualTo(String value) {
            addCriterion("SITEID <=", value, "siteid");
            return (Criteria) this;
        }

        public Criteria andSiteidLike(String value) {
            addCriterion("SITEID like", value, "siteid");
            return (Criteria) this;
        }

        public Criteria andSiteidNotLike(String value) {
            addCriterion("SITEID not like", value, "siteid");
            return (Criteria) this;
        }

        public Criteria andSiteidIn(List<String> values) {
            addCriterion("SITEID in", values, "siteid");
            return (Criteria) this;
        }

        public Criteria andSiteidNotIn(List<String> values) {
            addCriterion("SITEID not in", values, "siteid");
            return (Criteria) this;
        }

        public Criteria andSiteidBetween(String value1, String value2) {
            addCriterion("SITEID between", value1, value2, "siteid");
            return (Criteria) this;
        }

        public Criteria andSiteidNotBetween(String value1, String value2) {
            addCriterion("SITEID not between", value1, value2, "siteid");
            return (Criteria) this;
        }

        public Criteria andInsertByIsNull() {
            addCriterion("INSERT_BY is null");
            return (Criteria) this;
        }

        public Criteria andInsertByIsNotNull() {
            addCriterion("INSERT_BY is not null");
            return (Criteria) this;
        }

        public Criteria andInsertByEqualTo(String value) {
            addCriterion("INSERT_BY =", value, "insertBy");
            return (Criteria) this;
        }

        public Criteria andInsertByNotEqualTo(String value) {
            addCriterion("INSERT_BY <>", value, "insertBy");
            return (Criteria) this;
        }

        public Criteria andInsertByGreaterThan(String value) {
            addCriterion("INSERT_BY >", value, "insertBy");
            return (Criteria) this;
        }

        public Criteria andInsertByGreaterThanOrEqualTo(String value) {
            addCriterion("INSERT_BY >=", value, "insertBy");
            return (Criteria) this;
        }

        public Criteria andInsertByLessThan(String value) {
            addCriterion("INSERT_BY <", value, "insertBy");
            return (Criteria) this;
        }

        public Criteria andInsertByLessThanOrEqualTo(String value) {
            addCriterion("INSERT_BY <=", value, "insertBy");
            return (Criteria) this;
        }

        public Criteria andInsertByLike(String value) {
            addCriterion("INSERT_BY like", value, "insertBy");
            return (Criteria) this;
        }

        public Criteria andInsertByNotLike(String value) {
            addCriterion("INSERT_BY not like", value, "insertBy");
            return (Criteria) this;
        }

        public Criteria andInsertByIn(List<String> values) {
            addCriterion("INSERT_BY in", values, "insertBy");
            return (Criteria) this;
        }

        public Criteria andInsertByNotIn(List<String> values) {
            addCriterion("INSERT_BY not in", values, "insertBy");
            return (Criteria) this;
        }

        public Criteria andInsertByBetween(String value1, String value2) {
            addCriterion("INSERT_BY between", value1, value2, "insertBy");
            return (Criteria) this;
        }

        public Criteria andInsertByNotBetween(String value1, String value2) {
            addCriterion("INSERT_BY not between", value1, value2, "insertBy");
            return (Criteria) this;
        }

        public Criteria andInsertDateIsNull() {
            addCriterion("INSERT_DATE is null");
            return (Criteria) this;
        }

        public Criteria andInsertDateIsNotNull() {
            addCriterion("INSERT_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andInsertDateEqualTo(Date value) {
            addCriterion("INSERT_DATE =", value, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateNotEqualTo(Date value) {
            addCriterion("INSERT_DATE <>", value, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateGreaterThan(Date value) {
            addCriterion("INSERT_DATE >", value, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateGreaterThanOrEqualTo(Date value) {
            addCriterion("INSERT_DATE >=", value, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateLessThan(Date value) {
            addCriterion("INSERT_DATE <", value, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateLessThanOrEqualTo(Date value) {
            addCriterion("INSERT_DATE <=", value, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateIn(List<Date> values) {
            addCriterion("INSERT_DATE in", values, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateNotIn(List<Date> values) {
            addCriterion("INSERT_DATE not in", values, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateBetween(Date value1, Date value2) {
            addCriterion("INSERT_DATE between", value1, value2, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateNotBetween(Date value1, Date value2) {
            addCriterion("INSERT_DATE not between", value1, value2, "insertDate");
            return (Criteria) this;
        }

        public Criteria andDistIsNull() {
            addCriterion("DIST is null");
            return (Criteria) this;
        }

        public Criteria andDistIsNotNull() {
            addCriterion("DIST is not null");
            return (Criteria) this;
        }

        public Criteria andDistEqualTo(String value) {
            addCriterion("DIST =", value, "dist");
            return (Criteria) this;
        }

        public Criteria andDistNotEqualTo(String value) {
            addCriterion("DIST <>", value, "dist");
            return (Criteria) this;
        }

        public Criteria andDistGreaterThan(String value) {
            addCriterion("DIST >", value, "dist");
            return (Criteria) this;
        }

        public Criteria andDistGreaterThanOrEqualTo(String value) {
            addCriterion("DIST >=", value, "dist");
            return (Criteria) this;
        }

        public Criteria andDistLessThan(String value) {
            addCriterion("DIST <", value, "dist");
            return (Criteria) this;
        }

        public Criteria andDistLessThanOrEqualTo(String value) {
            addCriterion("DIST <=", value, "dist");
            return (Criteria) this;
        }

        public Criteria andDistLike(String value) {
            addCriterion("DIST like", value, "dist");
            return (Criteria) this;
        }

        public Criteria andDistNotLike(String value) {
            addCriterion("DIST not like", value, "dist");
            return (Criteria) this;
        }

        public Criteria andDistIn(List<String> values) {
            addCriterion("DIST in", values, "dist");
            return (Criteria) this;
        }

        public Criteria andDistNotIn(List<String> values) {
            addCriterion("DIST not in", values, "dist");
            return (Criteria) this;
        }

        public Criteria andDistBetween(String value1, String value2) {
            addCriterion("DIST between", value1, value2, "dist");
            return (Criteria) this;
        }

        public Criteria andDistNotBetween(String value1, String value2) {
            addCriterion("DIST not between", value1, value2, "dist");
            return (Criteria) this;
        }

        public Criteria andDocumentReceivcedTypeIsNull() {
            addCriterion("DOCUMENT_RECEIVCED_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andDocumentReceivcedTypeIsNotNull() {
            addCriterion("DOCUMENT_RECEIVCED_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andDocumentReceivcedTypeEqualTo(String value) {
            addCriterion("DOCUMENT_RECEIVCED_TYPE =", value, "documentReceivcedType");
            return (Criteria) this;
        }

        public Criteria andDocumentReceivcedTypeNotEqualTo(String value) {
            addCriterion("DOCUMENT_RECEIVCED_TYPE <>", value, "documentReceivcedType");
            return (Criteria) this;
        }

        public Criteria andDocumentReceivcedTypeGreaterThan(String value) {
            addCriterion("DOCUMENT_RECEIVCED_TYPE >", value, "documentReceivcedType");
            return (Criteria) this;
        }

        public Criteria andDocumentReceivcedTypeGreaterThanOrEqualTo(String value) {
            addCriterion("DOCUMENT_RECEIVCED_TYPE >=", value, "documentReceivcedType");
            return (Criteria) this;
        }

        public Criteria andDocumentReceivcedTypeLessThan(String value) {
            addCriterion("DOCUMENT_RECEIVCED_TYPE <", value, "documentReceivcedType");
            return (Criteria) this;
        }

        public Criteria andDocumentReceivcedTypeLessThanOrEqualTo(String value) {
            addCriterion("DOCUMENT_RECEIVCED_TYPE <=", value, "documentReceivcedType");
            return (Criteria) this;
        }

        public Criteria andDocumentReceivcedTypeLike(String value) {
            addCriterion("DOCUMENT_RECEIVCED_TYPE like", value, "documentReceivcedType");
            return (Criteria) this;
        }

        public Criteria andDocumentReceivcedTypeNotLike(String value) {
            addCriterion("DOCUMENT_RECEIVCED_TYPE not like", value, "documentReceivcedType");
            return (Criteria) this;
        }

        public Criteria andDocumentReceivcedTypeIn(List<String> values) {
            addCriterion("DOCUMENT_RECEIVCED_TYPE in", values, "documentReceivcedType");
            return (Criteria) this;
        }

        public Criteria andDocumentReceivcedTypeNotIn(List<String> values) {
            addCriterion("DOCUMENT_RECEIVCED_TYPE not in", values, "documentReceivcedType");
            return (Criteria) this;
        }

        public Criteria andDocumentReceivcedTypeBetween(String value1, String value2) {
            addCriterion("DOCUMENT_RECEIVCED_TYPE between", value1, value2, "documentReceivcedType");
            return (Criteria) this;
        }

        public Criteria andDocumentReceivcedTypeNotBetween(String value1, String value2) {
            addCriterion("DOCUMENT_RECEIVCED_TYPE not between", value1, value2, "documentReceivcedType");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}